Assuming your data is in A1:G4 and you have the value abc1 in H1 and C
in H2 then try:
=INDEX($A$1:$G$4,MATCH(H1,$A$1:$A$4,0),MATCH(H2,$A $1:$G$1,0))

Hope this helps
Rowan

CDog wrote:
Trying to get value to return from a table where the row and column reference
intersect and to bring that value back to the previous worksheet.

EG table looks a litle like this
A B C D E F
abc1 10 12 14 16 22 57
abc2 20 22 25 29 34 60
abc3 50 67 85 99 105 110

So say I wanted to bring back the value where abc2 and c intersect = 25

How do I do this?