extracting product z from an xyz table

[John Walker]

I cannot find a formula to extract value z from a 3-way
xyz table, eg, by analogy, the simple year 3 times table,
with horizontal 1 - 12 values and vertical 1-12 values.
VLOOKUP is ok for 2-way tables but not for this 3-way
application.

Any suggestions?

 

[J.E. McGimpsey]

Can you give a bit more detail on how your data is laid out?

I'm not sure what a 3-way application is.

You can do a second lookup inside VLOOKUP, i.e.:

Lookup1 value in A1, lookup2 value in B1, table in Sheet1!A1:L100,

=VLOOKUP(A1, Sheet1!A2:L100,MATCH(B1,Sheet1!A1:L1,FALSE),FALSE)