Find First Instance of Word and Copy to Cell Depending on Other Cell Value

On Sheet1 I want to find the first instance of one of these four words exactly (Big, Small, Fat, Thin) in Column B only. Once found, it needs to look two cells directly to the right of where it is found and if the cell equals what's in C1 then paste the letter "H" and the number directly to the left of where the word is found into sheet3 cell A3. It also needs to know that if two cells directly to the right of where it is found equals what's in cell D1 then paste the letter "A" and the number directly to the left of where the word is found also into sheet3 cell A3.

Originally Posted by bulina2k

niceee... ! Is there a priority of the searched terms ? Or whatever comes first ? (smallest found row)

Whatever comes first!

Something like this

Please Login or Register  to view this content.

Solved. Excellent jindon!

You are welcome and thanks for the rep.