Hi, I am sure i am making this more complicated than it has to be but i am trying to write a formula that looks at 3 separate columns and then from a table if there is a match return the value. Here is an example attached. I really need help with this. I think i could use a combination of Index Match but i can't get it to work.
Lookup.xlsx
what if there is a match in more that one column ?
can you give some example results expected in column E
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
not sure to have understood, in E2 and below:
Formula:
=IF(COUNTIF(Lookup!$E$4:$E$22,A2),A2,IF(COUNTIF(Lookup!$E$4:$E$22,B2),B2,IF(COUNTIF(Lookup!$E$4:$E$22,C2),C2,"")))
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi,
Not really understood: but try below formula in E2 and copy down.
Formula:=LOOKUP(2,1/COUNTIF(Lookup!$E$4:$E$22,A2:C2),A2:C2)
Regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks