Ask a new question

How to display the name of the highest rated movie on my list?

In the 'movie stats' table i want to display the name of the highest (imdb) rated movie. The ratings are in the E column and the titles of the movies are in the A column. I tried =VLOOKUP(MAX(E2:E),(A2:E),1,FALSE) which is the errors you see in the 'movie stats' table. Any help would be appreciated.
Answer
Answer

VLOOKUP doesn't work 'backwards' - it can only look up a value in the first column and return values in subsequent columns.

Try =INDEX(A2:A100,MATCH(MAX(E2:E100),E2:E100,0))

You will need to put a bounding limit on the bottom of the ranges  i.e. E2:E100, not E2:E

Regards

Murray
https://excel.dadsonion.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 226 Applies to: