Posted to microsoft.public.excel.programming

thiaga

external usenet poster

Posts: 19

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Intersect Line	GoodTrouble	Charts and Charting in Excel	4	January 29th 08 05:08 PM
How do I find where a column value and row value intersect?	Amy	Excel Worksheet Functions	2	January 12th 05 11:19 PM
opposite of intersect	David C.	Excel Programming	2	August 25th 04 05:45 PM
Intersect Formula VBA Help	scrabtree	Excel Programming	1	October 15th 03 02:08 PM
Help with If Not Intersect	derek	Excel Programming	6	July 11th 03 04:39 PM

All times are GMT +1. The time now is 05:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us