hello

i need to work on a file that has 2 sheets, sheet 2 has the legend for every word and sheet 1 has the answers of the questions. it works like this

Sheet 1 has the answers like this

professional, friendly, innovative.

Sheet 2 has the legend like this

39 Professional, Smart,
6 Friendly, Interesting
25 Innovative, Learning
etc etc.

Can excel find the legend and then enter the code into a box in sheet 1?

Sorry for the bad explanation, i'm just really tired.

Regards