I have a spreadsheet showing the rank of fruit by company and region. The user can change the company and region, but I am looking for a formula that will match the rank 1-4 and list values associated with the selected region.
Attached is the workbook, but if the user selected the company Nestle and Central Region, the formula would match rank 1 for that region resulting in a value of orange, rank 2 - strawberry, rank 3- Apple and rank 4 - Kiwi.
Thank you!
Formula:
=index($b$2:$b$5,match($j3,index($d$2:$g$5,,match($k$2,$d$1:$g$1,0)),0))
If that takes care of your original question, please select Thread Tools from the menu link above and 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