Row Column intersect

[thiaga]

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..

 

[Harlan Grove]

thiaga wrote...

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..

If you've given these ranges workbook-level names, you don't need the
worksheet name. If so, you should use

=INDIRECT(H1) INDIRECT(H2)

But if you used worksheet-level names, you need to put the worksheet
qualifier inside the INDIRECT calls,

=INDIRECT("Sheet1!"&H1) INDIRECT("Sheet1!"&H2)
=INDIRECT("Sheet2!"&H1) INDIRECT("Sheet2!"&H2)

I'd guess you meant to create worksheet-level names, so you'd have the
same names on each worksheet referring to the same cells within the
worksheet, but Insert > Name > Create only creates workbook-level names.