In E2 cell
Formula:
=LOOKUP(2,1/(A:A=D2),B:B)
Drag it down...
In E2 cell
Formula:
=LOOKUP(2,1/(A:A=D2),B:B)
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Sixthsence ,
U really amazing. Thank you,
Baskar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks