Hi,
I need help with Lookup or any other option to look up data, and put another data to the cell.
Please refer to the screen capture and excel file.
Thank you
Hi,
I need help with Lookup or any other option to look up data, and put another data to the cell.
Please refer to the screen capture and excel file.
Thank you
Try this in G3:
=INDEX(B:B,MATCH(E3,A:A,0))
or
=VLOOKUP(E3,A:B,2,FALSE)
Or
=LOOKUP(E3,$A$3:$B$12)
You can never have too many options I guess
HTH
Regards, Jeff
Thank you!!!!!!
You are very welcome and thanks for the feedback. We are happy to help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks