Row column intersect

T

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Row Column intersect 1
Using the INDIRECT function across multiple worksheets 0
Array with many cells from a row but not in order or together 11
COUNTIF + ADDRESS Issue 1
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0
Macro beginner help with making tables 1

Top