Closed Thread
Results 1 to 5 of 5

Nesting Multiple VlooKups

  1. #1
    Registered User
    Join Date
    09-25-2006
    Posts
    12

    Nesting Multiple VlooKups

    What I'm trying to do is create a formula that will look at the data in cell N8 on sheet1 (Form) and if there is a match on sheet2 (Contact) in column H then count four cells to the right and retrieve the data to sheet1, cell N10. I'm currently able to do that with a vlookup formula. The tricky part is that if the match cannot be found in column H, I want it to look in column J and if found retreive the data four cells to the right back to sheet1, cell N10. There's a total of 4 columns that I need to search for a match and retrieve the data four cells to the right from whatever the column the match is found in.

    Attached is my worksheet for clarification.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by buckchow
    What I'm trying to do is create a formula that will look at the data in cell N8 on sheet1 (Form) and if there is a match on sheet2 (Contact) in column H then count four cells to the right and retrieve the data to sheet1, cell N10. I'm currently able to do that with a vlookup formula. The tricky part is that if the match cannot be found in column H, I want it to look in column J and if found retreive the data four cells to the right back to sheet1, cell N10. There's a total of 4 columns that I need to search for a match and retrieve the data four cells to the right from whatever the column the match is found in.

    Attached is my worksheet for clarification.
    =IF(OR(ISERROR(VLOOKUP(N8,Contact!H:L,5,FALSE)),ISBLANK(VLOOKUP(N8,Contact!H:L,5,FALSE))),IF(OR(ISERROR(VLOOKUP(N8,Contact!I:M,5,FALSE)),ISBLANK(VLOOKUP(N8,Contact!I:M,5,FALSE))),IF(OR(ISERROR(VLOOKUP(N8,Contact!J:N,5,FALSE)),ISBLANK(VLOOKUP(N8,Contact!J:N,5,FALSE))),IF(OR((ISERROR(VLOOKUP(N8,Contact!K:O,5,FALSE))),ISBLANK(VLOOKUP(N8,Contact!K:O,5,FALSE))),"non",VLOOKUP(N8,Contact!K:O,5,FALSE)),VLOOKUP(N8,Contact!J:N,5,FALSE)),VLOOKUP(N8,Contact!I:M,5,FALSE)),VLOOKUP(N8,Contact!H:L,5,FALSE))

    --

  3. #3
    Registered User
    Join Date
    09-25-2006
    Posts
    12

    Nested vlookups

    Bryan,
    Thank you, thank you, thank you!!!! The formula works perfectly. I struggled for 2 days trying to get it to work before your help.

  4. #4
    Registered User
    Join Date
    02-18-2011
    Location
    dasss
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Nesting Multiple VlooKups

    I need to do a vlookup on cell A1 the entity code, "BO00", and I have an array with 10 columns the first 4 contain entity codes that I want to match to A1. For example there different entity codes in row 1 of the array (IE BO00, BO01, BT11, BY11) relating to the same data in column 5 and 6 of the row (IE entity name, West China holding LLC, and entity ID number, 123-56654)
    How can I do multiple v lookups on the first 4 columns in this row to get the same results of column 5, entity name?

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Nesting Multiple VlooKups

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Closed 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