I've been looking on the web for a solution but can't get it right. How would I go about showing the pay (data inside the table) based on the users selection? Basically, the user will choose a year, rank, and then time. I'm getting lost on a result. I know index and match will do the trick but can't get the syntax right. Would a sumproduct be useful here?
Pictures are worth a thousand words but spreadsheets are worth so much more. Attached is mine.
Thanks in advance. Rep to whomever helps!
Bookmarks