VLOOKUP + CHOOSE (reversed lookup) Function in Excel: Syntax, Examples and Free Practice
VLOOKUP + CHOOSE (reversed lookup) is an Excel Lookup & Reference function. Uses CHOOSE to rearrange columns on the fly, letting VLOOKUP look up a value using a column that's positioned AFTER the result column (which plain VLOOKUP can't do).
VLOOKUP + CHOOSE (reversed lookup) syntax
Arguments
lookup_value: Value to search forlookup_col: Column with the value to searchreturn_col: Column to return, positioned before lookup_col
When to use VLOOKUP + CHOOSE (reversed lookup)
Looking up a product name using its ID, even though the ID column sits to the right of the name column.
Practice VLOOKUP + CHOOSE (reversed lookup) online, free
Open the live Excel-style spreadsheet and try VLOOKUP + CHOOSE (reversed lookup) yourself. No Excel install or sign-up needed to start.
Practice VLOOKUP + CHOOSE (reversed lookup) now →More Lookup & Reference functions
Frequently asked questions
What does the VLOOKUP + CHOOSE (reversed lookup) function do in Excel?
Uses CHOOSE to rearrange columns on the fly, letting VLOOKUP look up a value using a column that's positioned AFTER the result column (which plain VLOOKUP can't do).
What is the syntax of VLOOKUP + CHOOSE (reversed lookup) in Excel?
The syntax is =VLOOKUP(lookup_value, CHOOSE({1,2}, lookup_col, return_col), 2, FALSE). lookup_value: Value to search for; lookup_col: Column with the value to search; return_col: Column to return, positioned before lookup_col.
Where can I practice VLOOKUP + CHOOSE (reversed lookup) online for free?
Open the free live spreadsheet on Cellgrids and try VLOOKUP + CHOOSE (reversed lookup) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts