vlookup error

J

Jim

Hello,

Using vlookup and when referencing a blank cell I am receiving a ‘0’ I have
tried using

=IF(ISERROR(VLOOKUP(F15,Input!$1:$65536,N15,FALSE)),"
",VLOOKUP(F15,Input!$1:$65536,N15,FALSE)) however I am still receiving a 0.

Any thoughts
 
D

daddylonglegs

You could use something like

=IF(VLOOKUP(F15,Input!$1:$65536,N15,0)<>"",VLOOKUP(F15,Input!$1:$65536,N15,0),"")

although that will still give #N/A! if F15 doesn't exist in the lookup
range
 
Top