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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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