Returning a Column to the Left
Key points
- Enter the ranges
- See the formula
- Copy it
In INDEX MATCH Builder you can return a column to the left of the search column.
Steps
- Enter the ranges
- See the formula
- Copy it
VLOOKUP cannot return a column to the left.
Use "Build an INDEX and MATCH Formula" (free)
Tools that go well with this
- Build a VLOOKUP or XLOOKUP Formula: Build VLOOKUP and XLOOKUP formulas.
- Build a FILTER Formula: Build a FILTER formula.
- Build a SUMIF or COUNTIF Formula: Build SUMIF and COUNTIF formulas.