I would like to have a formula that checks if a value from column B occurs in cell A1. If it does, I want it to return the value from column C corresponding with the value from B.
An example:
ExampleX2.xlsx
Kind regards and thanks in advance!
boomcie
VLOOKUP will do the trick
=VLOOKUP(A2,$B$2:$C$16,2,0)
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
=MATCH(A2,B$2:B$16,0)
Some of your Output is wrong.
Max Williams is not No. 1 in the B list, he's simply not there.
Jan Jones and Kat Mary Richards are also not there.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
=MATCH(A2,B$2:B$16,0)
Some of your Output is wrong.
Max Williams is not No. 1 in the B list, he's simply not there.
Jan Jones and Kat Mary Richards are also not there.
I'm trying to match in the other direction and not an exact match. So "Kat Mary" does occur in A14. I know it's somewhat unclear perhaps, but not sure how to better explain this.
=LOOKUP(1E+100,SEARCH(B$2:B$16,A2),C:C)
Is the formula I was looking for. Figured it out after a lot of contemplating. In my example it fails on row 11, but that's because I made my example so basic.
Thanks for everyone who answered.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks