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.
Peace of mind is found in some of the strangest places.
post it austenr, or a small example.....workbook that is.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
I figured it out. Thanks Steve.
Peace of mind is found in some of the strangest places.
something like:
=IF(H5<>"",..... ??
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
=IF(ISNA(VLOOKUP(G19,Brand!A3:B551,2,FALSE)),"",VLOOKUP(G19,Brand!A3:B551,2 ,FALSE))
Thanks GG, thats what I came up with after I shook out the cob webs
Peace of mind is found in some of the strangest places.
Posting Permissions
Reply With Quote
