Return value with text

[KirstenExcel]

Hi,

I am hoping somebody can help me with a formula for what I would like to achieve. I will try to explain what I am trying to do.

We use Accountview at work and when I generate a report for the contracts, it will generate an Excel file which uses the PM coding instead of the names. Each code represents a specific program manager within the company. I added an extra column which should be filled with the name of the program manager instead of the code. I also created a reference table which shows the matching name for each code. What formula do I have to use in order to have the matching program manager name? To make it more clear I attached an example document.

Regards,
Kirsten

[Glenn Kennedy]

In E3, copied down:

=INDEX($K$3:$K$6,MATCH(D3+0,$J$3:$J$6,0))

[zbor]

Format cells as General. Not text. Text won't recognize number 18 same as text "18".

Then use:

Please Login or Register  to view this content.

You can add more data in table below.

[Glenn Kennedy]

or convert the text in D3 downwards from TEXT to General and omit the +0 from the formula, above. Best NOT to do this if there can be leading zeros in the PM code.

[KirstenExcel]

Thank you all. I managed to get it done.

Mission accomplished