Vlookup and Hlookup combined

=INDIRECT(ADDRESS(MATCH(A3,A$10:A$11,0)+9,MATCH(B3,B$9:C$9,0)+1))
In C3 and copy down

Add a helper column to the left of your table. Concatenate both columns to create the lookup value. =B3&C3 works

In your table concatenate the vertical and horizontal elements in your extended table.

=VLOOKUP($B10&C$9,$A$2:$D$6,4,FALSE)

Hey Presto. Hide column A if you don't want to see it.

Hope this helps

Chris

Thanks Chris! Brilliant solution and also dynamic.

Ooops, sorry, misread your post and did it backwards:
=INDEX($C$3:$C$6,MATCH(INDEX($A:$A,ROW(B10))&INDEX($9:$9,COLUMN(B10)),$A$3:$A$6&$B$3:$B$6,0))

That's another option without a helper column. It's an array formula so needs confirming with ctrl+shift+enter, drag across/down as neccessary.

concatch
Vlookup and Hlookup combined

Hi,

I'm not sure if I need a vlookup and and hlookup in a single formula.

I have attached a workbook. In short I have two tables and the cells highlighted in yellow need to pull the correct figures from the above table. Basically it need to read off an intersection.

Any help would be appreciated.


Hey Buddy here is the solution of your problem. You can download the sheet and check it.