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
Bookmarks