Help w/ returning cell value based upon matching text from a different list

[CRBV]

Hi,

So I'm racking my brain here and can't seem, for some reason, to come up with something that solves this (I'm fairly advanced with Excel too).

Problem: I have a list of text values and another list of text values with costs ($) associated with those text values (in another column). The second list is more extensive, and thus does not exactly match up to the initial. I need to take the text value from the first list, search in the second for a match, and then return the cost value that is associated with the match from the second list.

Any ideas?

[oeldere]

index / match

or maybe

VLookup

[CRBV]

Right--so would this check out? It returned the correct value first try, but perhaps I need to use $ to lock it in.

=INDEX(PBI!A2:D76,MATCH(MMP!A2,PBI!A2:A76,0),4)


Edit:=INDEX(PBI!A$2:D$76,MATCH(MMP!A2,PBI!A$2:A$76,0),4), SOLVED.

Thanks!

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.