Foirmle
By umitgunes Dé hAoine, 04 Deireadh Fómhair 2019
Posted in Kutools le haghaidh Excel
Freagraí 2
Is maith 0
tuairimí 7.3K
Vótaí 0
Haigh,
I used your formula and find like =A1 and the A1 value is VALUE1
It doesn't show VALUE1, It just shows =A1
Hoca can I convert it to a formula and see VALUE!
Go raibh maith agat
Dia duit,
Can you please tell us how to replicate the issue?
Go raibh maith agat
Excelfans
·
blianta 4 shin
·
0 Is maith
·
0 Vóta
·
0 Comments
·
Haigh,
My code is ="='Sayı Endeksi'!E"&""&IF(ISNUMBER(MATCH(D89;'Sayı Endeksi'!$D$1:$D$100000));MATCH(D89;'Sayı Endeksi'!$D$1:$D$100000);0&"")
It gives me =A1 but I want to get the value of A1 not the =A1 display.
Go raibh maith agat
umitgunes
·
blianta 4 shin
·
0 Is maith
·
0 Vóta
·
0 Comments
·
Féach ar an bPost Iomlán