Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLookup over multiple worksheets Excel 2003

    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Something like:
    =if(isna(VLOOKUP($B$4,'Warehouse 1 to 199999'!$A$2:$G$54224,2,FALSE)),"",VLOOKUP($B$4,'W arehouse 1 to 199999'!$A$2:$G$54224,2,FALSE))

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •