We need a solution to what we think is a simple problem.
We have a spreadsheet of 8000 text items in sheet1. We would like to compare an external list of words (in a second worksheet) to column A in Sheet1 (named TW) in the spreadsheet and, if any word matches a word, check to see what level it is (column C—named LEVEL). If it matches both in both A and C, how do I insert the word in column B in the cell?

Something like this, although I know this DOES NOT work!!! =IF(and(TW=A2,LEVEL=2.0)),(ROW()),B

We cannot use a VLOOKUP or MATCH because there are multiple identical items in Column A; it is the rest of the row that makes it unique.

I want to insert the item from Column B in a worksheet that is sorted by Levels. The first set of cells would show the formula and the second set, how it should look if the formula worked! Now sure if it will display correctly in this post.
A B C D E F
Search items Level 1.0 Level 1.5 Level 2.0 Level 2.5 Level 3.0
Ability =IF(and(TW=A2,LEVEL=2.0)),(ROW()),B/


A B C D E F
Search items Level 1.0 Level 1.5 Level 2.0 Level 2.5 Level 3.0
Ability Skill