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!!
Bookmarks