Vlookup?

[gbWildy]

i have several vlookups in sheet 2, that is taking data from sheet 1.

it works perfectly when i need to see the data i am after, but sometimes i need the cell to be blank when i do not require it to look up information.

the formula that im using is
=VLOOKUP(C5,STOCK2,2,FALSE)

when C5 is blank, this cell shows up as #N/A.

how do i make this cell blank if cell C5 is blank?

any suggestions?

[JChandler22]

Try this (untested, but should work):

=IF(ISERROR(VLOOKUP(C5,STOCK2,2,FALSE)),"",VLOOKUP(C5,STOCK2,2,FALSE))

[gbWildy]

yes it works

thank you