J
jamie85
Is there a way that i can hide the #N/A that appers in a cell with
lookup when there is no value in it? Thankyou
lookup when there is no value in it? Thankyou
J
Jerry W. Lewis
=IF(ISNA(<formaula>),"",<formula>)
Jerry
Jerry
T
tolgag
Hi,
Try following ws-function :
=IF(ISNA(your_lookup_function);;your_lookup_function
Try following ws-function :
=IF(ISNA(your_lookup_function);;your_lookup_function
J
jamie85
=IF(ISNA(=VLOOKUP(A2,STOCK,2)),"",=VLOOKUP(A2,STOCK,2))
That is what i currently have but it isn't working. Any idea why
Thanks
That is what i currently have but it isn't working. Any idea why
Thanks
T
tolgag
should be like this :
=IF(ISNA(VLOOKUP(A2,STOCK,2)),"",VLOOKUP(A2,STOCK,2))
=IF(ISNA(VLOOKUP(A2,STOCK,2)),"",VLOOKUP(A2,STOCK,2))
J
jamie85
Great that works thanks 