Hiding #N/A
 

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

--
Message posted from http://www.ExcelForum.com

Hiding #N/A
 

=IF(ISNA(<formaula),"",<formula)

Jerry

jamie85 < wrote:

Is there a way that i can hide the #N/A that appers in a cell with a
lookup when there is no value in it? Thankyou.

Hiding #N/A
 

Hi,

Try following ws-function :

=IF(ISNA(your_lookup_function);;your_lookup_functi on

--
Message posted from http://www.ExcelForum.com

Hiding #N/A
 

=IF(ISNA(=VLOOKUP(A2,STOCK,2)),"",=VLOOKUP(A2,STOC K,2))

That is what i currently have but it isn't working. Any idea why
Thanks

--
Message posted from http://www.ExcelForum.com

Hiding #N/A
 

should be like this :

=IF(ISNA(VLOOKUP(A2,STOCK,2)),"",VLOOKUP(A2,STOCK, 2))


---
Message posted from http://www.ExcelForum.com/

Hiding #N/A
 

Great that works thanks :)


---
Message posted from http://www.ExcelForum.com/