Lookup Function Searching For The Nth Largest Number | Excel Tutorials

Опубликовано: 23 Март 2026
на канале: Calon Heindel
581
4

Excel Templates: https://calonheindel.etsy.com/

Office 365 (Excel): https://amzn.to/45E9lCA

Start a Print On Demand Etsy Store with Printful: https://www.printful.com/a/8269674:5b...

Looking to make money as a freelancer? Sign up and use Fiverr:
https://go.fiverr.com/visit/?bta=7370...

Standing Desk:
https://amzn.to/3AOe32H

Book that changed my life:
https://amzn.to/3Q4peME

Great book on business:
https://amzn.to/48QOs9U

Royalty Free Music:
https://share.epidemicsound.com/64td0d

Learn how to use a lookup function searching for the Nth largest number. Basically, you search for the Nth largest number that you specify and match that to a column to display the desired value. This formula uses the LARGE function and the INDEX MATCH lookup function.

Find 2nd and 3rd highest numbers in a row and match to column header. Search for the largest number and display the value from another column.

Disclaimer & Full Disclosure:

NOT FINANCIAL ADVICE

*I am not a financial advisor, so this should not be taken as financial advice. For investment advice please seek the counsel of a financial/investment advisor(s); and conduct your own due diligence.

We are a a participant in the Amazon Associates Program, So If you purchase something from our affiliate links will get a small commission with no extra cost to you. This makes it possible for us to keep producing VIDEOS!
°We NEVER collect, store, use, or have access to any data about you.