Vlookup based on values from two columns

[lamp12]

I have a spreadsheet (Excel 2010). I want to fill categoryid in Sheet One based on values of Skill and State which are part of field in Sheet two.
Sheet One (Has Four Columns and I am looking for filling CategoryID based on Sheet Two
FirstName LastName Skill State CategoryID
John Edward Ballet California
Ed Catalino Tap London
Natasha Curtis Ballet Australia
Shen Watson Modern Kansas
Sheet Two
CategoryID CategoryDescription
1 Dancers/Ballet/United States/Alaska
2 Dancers/Ballet/United States/California
3 Dancers/Ballet/UnitedKingdom/Wales
4 Dancers/Ballet/UnitedKingdom/London
5 Dancers/Tap/United States/Alaska
6 Dancers/Tap/United States/California
7 Dancers/Tap/United Kingdom/Wales
8 Dancers/Tap/United Kingdom/London
9 Dancers/Ballet/Australia
10 Dancers/Modern/United States/Kansas
Appreciate your help.

 

[Oeldere]

I think your double posted your tread.

In the link below you get already your answer.

http://www.excelforum.com/excel-general/835610-vlookup-based-on-values-from-two-columns.html

 

[lamp12]

Sorry, I was so frustrated, I posted on two forums. But did not know how good people are in quickly responding. You guys are amazing. Thank you.

 

[Oeldere]

Then, please mark your tread as solved.

 

[lamp12]

I tried to look how to mark the tread "closed or solved". I did not find a place to do that. Can you help me with that answer also. Thank you.

 

[Oeldere]

Isn't on the left (above) you first question.