LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default How can I do this ??

I have a spreadsheet (call it a matrix) that has item numbers going down
column A and item numbers going across row 1. I need to find the
intersection of any two item numbers based upon item numbers in a different
spreadsheet (call it a plan) in consecutive rows. Let me illustrate:

The Matrix:

Row 1 - item1 item2 item3
Col A ------ ------- -------
------
item1 1.0 1.5 1.25
item2 1.5 1.0 2.0
item3 1.25 2.0 1.0

The Plan:

row 1- item1 and a bunch of other stuff in other columns
row 2- item3 and a bunch of other sutff in other columns

What I need to be able to do is use the item numbers from row 1 and row 2 to
get the value from the Matrix....the value is where item1 and item3 intersect
in the Matrix. So for this example, the value returned would be 1.25.

Does this make any sense.....and is it possible ??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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



All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"