I have a sheet that uses VLOOKUP and if I don't have a value in the cell I get an #N/A error. My formula isSo if I leave A20 blank I get #N/A errors in my "units" cell. I think I need an IF statement somewhere somehow!!! Any ideas?Please Login or Register to view this content.
Bookmarks