Using MATCH() and HLOOKUP() to find table value

with No Comments

www.excelguru.noThis example is actually about trees. Håkon wants to input one value from a row and one from the heading and get the table value from the cell where the row and column intersect. So, like in the image, if he is searching for Age 15 and Site Quality 14, he wants 119 to be returned. To achieve this, we use MATCH to find the correct row, and HLOOKUP to find the correct column.

We also use Data Validation to restrict the input values.

Using-Match-and-Hlookup-to-find-table-value

 

Download the workbook here: HLOOKUP-AND-MATCH-TO-FIND-TABELVALUE.xlsx (476 downloads)