Hi All
I'm looking to return a lookup value based on a set of data that has duplicate values. Attached is the a file that contains the issue I am facing. The end result that I am looking for is from Cell I3 to L3. What I need is a formula that looks up at Cell C2 within the data range of E3:F19 and the results should be in I3 to L3. Cell C2 has to be in months. Appreciate your assistance on this.
Best regards
Tamil
In I3:
=IFERROR(INDEX($F$3:$F$19,MATCH(1,($E$3:$E$19=I$2)*($F$3:$F$19=$C$2),0)),"")
... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Once entered, drag copy across.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you Ali! for the quick turnaround. It worked like a peach!.....Have a great Sunday.
Best regards
Tamil
You, too - you're welcome!
Here a modified Ali's formula that doesn't need CTRL+SHIFT+ENTER
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks