Two-way lookup

• Snippet
• Lookups
• 5 blanks to fill

=INDEX(Table, MATCH(Row value, Row headers, 0), MATCH(Column value, Column headers, 0))

About this template

Row and column match.

Category

Spreadsheet formulas

Pack

Lookups

Type

Snippet, a short message

Asks for

Table, Row value, Row headers, Column value, Column headers

Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.

=INDEX({{Table}}, MATCH({{Row value}}, {{Row headers}}, 0), MATCH({{Column value}}, {{Column headers}}, 0))

More spreadsheet formulas templates

• Lookup last value Snippet Last non-empty cell.
• FILTER rows Snippet Rows that match.
• UNIQUE values Snippet Distinct list.
• SORT range Snippet Sorted copy.
• Check exists Snippet Is it in the list?
• IMPORTRANGE Snippet Sheets across files.

See all 75 spreadsheet formulas templates