I have this formula I'm using to lookup style numbers from a table on another sheet (called Items) and input the description.
My original formula was "=IF(F3="","",VLOOKUP(F3,Items!A:D,2,FALSE))"
This worked great in that it removed the #N/A message if the cell was left blank and it looked up...