Results 1 to 4 of 4

Nested Vlookup & Match

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    Utah, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Nested Vlookup & Match

    I have my data in Data Tab as follows:
    ID Desc Cat
    1 yes decision
    2 no final
    3 12/31/10 decision
    4 misc final
    5 1/1/11 decision
    6 no review
    7 yes final
    8 1/5/11 review
    9 1/6/11 final
    10 1/7/11 review
    1 na review
    3 part review
    7 sold decision

    I then I have two lookup tables in Lookup1 and Lookup2 Tabs. Lookup1 has ID values:
    ID
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10

    and Lookup 2 has Cat values:
    Cat
    Descision
    Review
    Final

    Final Table first column has IDs that populates sorted IDs from Data tab. Column 2 Desc match (lookup) IDs off lookup1 to IDs from Data tab, then match (lookup) Cat from Lookup 2 to Cat in Data tab and when both matched, then it will populate values in Desc in Final Tab. PLease see Final Tab in attached Excel file.
    Do I need two vlookup and a match?

    Thanks,
    Attached Files Attached Files

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