PDA

View Full Version : Solved: VLOOKUP question



austenr
01-18-2010, 03:05 PM
Boy I have not been doing enough Excel lately. Trying to use a VLOOKUP and am getting the #N/A error. I think it is something like IF(ISERROR but cant remember the rest.

=VLOOKUP(G19,Brand!A3:B551,2,FALSE)

Whats the right syntax?

Forgot to mention, want the cell to be blank not 0.

lucas
01-18-2010, 03:19 PM
post it austenr, or a small example.....workbook that is.

austenr
01-18-2010, 03:34 PM
I figured it out. Thanks Steve.

lucas
01-18-2010, 03:40 PM
something like:

=IF(H5<>"",..... ??

geekgirlau
01-18-2010, 05:47 PM
=IF(ISNA(VLOOKUP(G19,Brand!A3:B551,2,FALSE)),"",VLOOKUP(G19,Brand!A3:B551,2,FALSE))

austenr
01-18-2010, 05:50 PM
Thanks GG, thats what I came up with after I shook out the cob webs :hi: