INDEX MATCH Formula Generator
Describe the lookup you need in plain English and get a ready-to-use INDEX MATCH formula for Excel or Google Sheets — more flexible than VLOOKUP, and can look in either direction.
5 free tries without an account
INDEX MATCH syntax
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))MATCH finds the position of lookup_value inside lookup_range; INDEX then returns whatever is at that position inside return_range. The 0 at the end of MATCH means "exact match", which is what you want almost every time. Formulon writes the nested formula for you and explains each part.
Examples
Look up a value to the left of the search column
=INDEX(A:A,MATCH(D2,B:B,0))MATCH finds the row where column B equals the value in D2, then INDEX returns the value from column A on that same row — even though A is to the left of B, which plain VLOOKUP can't do.
Two-way lookup: row and column both come from criteria
=INDEX(B2:F20,MATCH(H2,A2:A20,0),MATCH(H3,B1:F1,0))MATCH finds the row for the value in H2 within column A, and a second MATCH finds the column for the value in H3 within the header row — INDEX then returns the value at that exact row/column intersection.
Frequently asked questions
Why use INDEX MATCH instead of VLOOKUP?
VLOOKUP can only look up a value in the leftmost column of a range and return something to its right. INDEX MATCH can look up and return values in either direction, doesn't break if columns are inserted or reordered, and is generally faster on large sheets.
How does INDEX MATCH actually work?
MATCH finds the position (row number) of your lookup value within a column. INDEX then returns the value at that row number from a different column. Combined, they act like a lookup that can pull data from any column, not just ones to the right of the search column.
Is INDEX MATCH the same in Google Sheets?
Yes, both INDEX and MATCH have identical syntax and behavior in Excel and Google Sheets.
Can INDEX MATCH look up by two conditions at once?
Yes — this needs an array-entered MATCH across two concatenated criteria, or Excel 365's newer XLOOKUP/XMATCH with an AND-style array. It's one of the trickiest common formula patterns, which is exactly the kind of thing worth generating instead of writing by hand.
Don't want to write it by hand?
Describe what you need in plain English and get a ready-to-use formula in seconds.
Try the formula generator