VLookup over multiple worksheets Excel 2003

Topic

New Reply

My coversheet is set up to look at 2 different worksheets–Excel 2003 not 2007 or 2010
I’m using this formula =VLOOKUP($B$4,’Warehouse 1 to 199999′!$A$2:$G$54224,2,FALSE)
It works great but it will put a #N/A if the result is not in lets say Warehouse 200000 to 593609
Example
Locations PatName Results
Warehouse 1 to 19999 Smith, John
Warehouse 200000 to 593609 #N/A
how can I get rid of the #N/A and just have a blank if the result is not in there? Just to make it look a little nicer
Thanks for any help on this

Reply | Quote

Replies

Something like:
=if(isna(VLOOKUP($B$4,’Warehouse 1 to 199999′!$A$2:$G$54224,2,FALSE)),””,VLOOKUP($B$4,’Warehouse 1 to 199999′!$A$2:$G$54224,2,FALSE))

Steve

Reply | Quote