Vlookup based on values from two columns

**lamp123** · 06-04-2012, 01:10 PM

I have a spreadsheet (Excel 2010). I want to fill categoryid in sheet one based on values of SkillProblem.xlsx 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.

**tigeravatar** · 06-04-2012, 01:17 PM

lamp123,

Welcome to the forum!
Attached is a modified version of your posted workbook. In sheet 'Dancers' cell E2 and copied down is this formula:

Please Login or Register  to view this content.

**oeldere** · 06-04-2012, 01:29 PM

You also posted your question on this forum.

http://www.mrexcel.com/forum/showthr...=1#post3174856

**tigeravatar** · 06-04-2012, 01:33 PM

Thanks for cross-post link, oeldere.

lamp123, in the future, when you post a message that you will be posting (or have already posted) elsewhere, please include a link to the cross-post per forum rule 8 (link to forum rules in my sig).

**lamp123** · 06-04-2012, 01:41 PM

I am sorry that I posted on two forums. I was frustated and looking for reply. I had no idea someone will reply so quickly. Thank you tigeravatar for quickly reponding. I am so happy to try, Appreciate your help.