VLOOKUP or INDEX?

[emueller]

Hello, I'm sure this is really easy, but I'm not having any luck with figuring out the correct formula to get the desired results.

I'm trying to compare two lists in separate sheets. If there is a match, then return a value in a different column on the main sheet. I've tried using VLOOKUP and INDEX, but can't figure out the right way in order to get it to work.

I've attached a very simple sample file. The first 2 worksheets are samples of what I currently have. The third worksheet is how I would like the first worksheet to look once I get the correct formula in column C.

[63falcondude]

Try this in C2:

=IFERROR(INDEX(Assignments!A:A,AGGREGATE(15,6,ROW(Assignments!A$2:A$5)/ISNUMBER(SEARCH(Assignments!B$2:C$5,A2)),1)),"")

Drag the formula down.

[emueller]

Thank you, this does what I need it to do.

[63falcondude]

Happy to help. Thanks for the rep!