Nested Vlookup & Match

[Helal]

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. Final Tab:
ID Desc
1 yes
1 na
2 no
3 12/31/10
3 part
4 misc
5 1/1/11 e
6 no
7 yes
7 sold
8 1/5/11
9 1/6/11
10 1/7/11


Thanks,

 

[scottylad2]

You may wish to read the forum rules about cross posting,

maybe save some people in either forum some of their time

http://www.excelforum.com/excel-general/767224-nested-vlookup-and-match.html