Match cell with table heading & return #

[KCANBS]

Hi, I've attached a spreadsheet that I need help with a formula on. Thought it might be Index Match, but that doesn't work.

Need a formula in cell E43 that checks Cell D43 for a Tier #, then depending on what that Tier is, looks at cells D31:G31 to find the match, then returns the corresponding # (in this case should be 5) from row 32 (in this case E32.

Thanks so much for your help!!

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

[63falcondude]

Edit: Whoops... See post #2.

[KCANBS]

Sorry about that. I've corrected the thread title.

[63falcondude]

Try this in E43:

=INDEX($D$32:$G$37,MATCH(E$42,$C$32:$C$37,0),MATCH($D43,$D$31:$G$31,0))

Also notice that you are comparing BLUE BERRIES to BLUEBERRIES and RASP BERRIES to RASPBERRIES.

[KCANBS]

Worked perfectly! Thank you! Yes, I noticed the blue berries vs blueberries, it will be corrected on my main spreadsheet.

[AliGW]

Thanks for changing the title!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[63falcondude]

Happy to help.

[KCANBS]

Thanks, I was looking for that! Have a fantastic day!