lookup values

[OCM]

Hi,

Given the attached sample file, I would like to insert a column next to Status_ID, Department_ID, and User_ID, and name these columns as Status, Department, and User and populate descriptions from the (Status, Department, and User).

How can I accomplish this?

TIA

Regards,


OCM

 

[SkipVought]

Hi,

Made your 3 lookup tables Structured Tables via Insert > Tables > Table, named Table1, Table2, & Table3 respectively.

The formula, the same for all three but for the table and lookup references...
E2: =INDEX(Table1[[Description ]],MATCH(--B2,Table1[Status_ID],0),1)

Note, the double negatives in the MATCH() function coerces your lookup TEXT values to become NUMBERS, comparable with the lookup ranges in your three lookup tables.

Your workbook uploaded below.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[OCM]

SkipVought,
Thanks a lot for your suggestion. I was able to apply your solution and it is working as intended.

Regards,

OCM