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.
=VLOOKUP(G19,Brand!A3:B551,2,FALSE)
Whats the right syntax?
Forgot to mention, want the cell to be blank not 0.