Hi,

As well as OFFSET, we commonly use INDEX:

=INDEX(B2:D10,MATCH(F1,B1:D1,),MATCH(G1,A2:A10,))

--
Thanks,
Shane Devenshire


"MH" wrote:

Trying to reference the data in a cell that matches Both a column heading and
row heading.