Google Sheet with vlookup /hlookup

Question

How do I use the information in TABLE to find the number I want?

question from:https://stackoverflow.com/questions/66049261/google-sheet-with-vlookup-hlookup

Answer 1

You can also use:

=iferror(index(A9:D13, match(F9, A9:A13, 0), match(G9, A9:D9, 0)))

Using your table: