Hello All,
I am trying to figure out the Index Match Formula for the attached excel example. In the attached excel workbook, in O2 (highlighted in blue), I am trying to have the IndexMatch formula return the corresponding %% in the table to the left (From the grey section). The formula should be based on the criteria in M2 and N2, which are both drop downs. Any assistance would be greatly appreciated!
Thanks!
This should do what you want. Enter in O2 and format as % and no decimal places.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Here's another one...
=VLOOKUP(N2,A2:I12,MATCH(M2,A1:I1,0),0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Formula:Please Login or Register to view this content.
Thank you all for your assistance! This worked perfectly!
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
Done! Thanks Tony!Originally Posted by Tony Valko
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks