fx =SORT(A1:D100,2,-1)ABCSKU-4821Widget A$24.99SKU-7293Gadget B$89.50SKU-1056Tool C$12.75
🔍 Lookup

SORT Formula for Lookup

Sort a range dynamically. Copy-paste ready for Excel, Google Sheets, and Airtable.

=SORT(A1:D100,2,-1)
When you need this: When you need a leaderboard that auto-ranks employees by sales (column B) in descending order (highest sales first).

How it works

  1. 1Specify the array to sort (A1:D100).
  2. 2Choose the sort column (2 = column B, the sales column).
  3. 3Set sort order (-1 or FALSE = descending; 1 or TRUE = ascending).

Variations

Sort by multiple columns
=SORT(A1:D100,{2,3},{-1,1})
SORT with FILTER combined
=SORT(FILTER(A1:D100,B1:B100>1000),2,-1)

Related Formulas

VLOOKUP — Look up a value in a table by matching the first columnLookupINDEX/MATCH — Flexible lookup - more powerful than VLOOKUPLookupXLOOKUP — Modern replacement for VLOOKUP (Excel 365)LookupFILTER — Return rows matching criteria (dynamic filter)Lookup

Need a formula that's not here?

Generate custom formula →