Vlookup based on conditional match

[lljones]

Hi, have a spreadsheet with list of book titles in column c and page counts in column E.

Looking for vlookup formula that returns the title of the longest book -

Thanks for your help.

 

[kweaver]

Welcome to the lounge.

I didn't use a VLOOKUP for this. If the titles are in C1:Cn (I used a name range) and the number of pages are in E1:En (again, used a name range), then this should work (unless there's a tie in page numbers):

=INDEX(Titles,MATCH(MAX(Pages),Pages,0))

 

[lljones]

Thanks! Works like a charm.