[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 91
  • Last Modified:

find max with lookup

Hi,

attached is a spreadsheet where i must find the max contrubutor from the four regions in R:V

In W, it is manually entered.

I have attempted an INDEX formula with MAX but it is returning NA, can someone amend?

Thanks
Book1.xlsx
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Randy PooleCommented:
Use this:
=INDEX($R$1:$V$1,MATCH(MAX($R2:$V2),$R2:$V2,0))

Open in new window

0
 
Seamus2626Author Commented:
Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now