Find and return fix value in a cell

[endrei15]

Dear all,

I have a contractor number list with revision and date + client ID.
Every contractor number has a fix Client number(allocated).
In example: "ABC-2450-001" has a client fix ID equals to "CLT-0000-ABC-0001".

As ABC-2450-001, is being revise from Rev 1 onwards, how to get/find the fix Client ID and
return to column E (if we have received the latest revision) (please see attached example).

This date is getting huge, different contractor numbers with Fix client IDs, being revised.


Thanks for your help guys.

E

[Glenn Kennedy]

Maybe with the help of a lookup table:

=IF(D2="","",VLOOKUP(B2,H:I,2,FALSE))

[endrei15]

Thanks Glenn!

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.