Row column intersect
 

I have 2 matrices with the same header labels and i need to find the
intersecting value.

I put them in 2 sheets and did "Insert Name Create top row & left

column"


I have to look up the value based on a selection in another sheet.


I tried
"=Sheet1!Indirect(H1) Sheet1!Indirect(H2)"
"=Sheet2!Indirect(H1) Sheet2!Indirect(H2)"


but am not able to do indirect with sheet name..


Any ideas..