+ Reply to Thread
Results 1 to 2 of 2

vlookup to search multiple sheets

  1. #1
    Registered User
    Join Date
    07-31-2006
    Location
    UK
    Posts
    31

    vlookup to search multiple sheets

    hi all,
    i trying to use vlookup to search for a value in sheet "data" column A and search in sheets “import1, import2, import3” and return a value from column B.

    This is what I’ve been playing with:

    =IF(ISERROR(VLOOKUP($A1,import1!A:B,import2!A:B,import3!A:B,2,FALSE)),"",VLOOKUP($A1,import1!A:B,import2!A:B,import3!A:B,2, FALSE))

    with no luck

    Is there a way of using vlookup to search multiple sheets?

    Any help would be appreciated.

    thanks

  2. #2
    Forum Contributor
    Join Date
    09-25-2004
    Posts
    269
    Hi JAZZNAURA

    Lets see we could keep this simple. If your worksheets are returning a values then try...


    Please Login or Register  to view this content.

    But if they're returning texts then try...

    Please Login or Register  to view this content.
    If either these formulas don't work its better to post a sample of your workbook.

    Hope it helps!
    Last edited by vane0326; 09-03-2007 at 09:40 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1