Formula version

=INDEX(A1:M10,MATCH("Apple",A1:M1,0),MATCH("Orange ",A1:A10,0))

--
HTH

Bob Phillips

"StephanieH" wrote in message
...
Is it possible (through VBA or other methods) to activate the cell in a
table
where the column heading is Apple and the row heading is Orange?