Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have three matrices(see below), I would like to have excel lookup based on
the column and row(ex. [3,7]) and search the other matrices for the same column and row numbers and add them together(ex. [3,7] + [3,7] = Y+ J). However I am not sure how to go about doing this. Any help would be greatly appreciated. [1 2 5 6] A B D E [1] B E H F [2] J U T D [5] U Y P P [6] [2 3 6 7] A B D E [2] B E G F [3] J S D D [6] U Y P P [7] [3 4 7 8] A B D E [3] B E G F [4] J S D D [7] U Y P P [8] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Where to find complex matrix math add-ins for Excel 2003? | Excel Worksheet Functions | |||
How can i build up a Matrix in EXCEl ? | Excel Worksheet Functions | |||
How do I print a file holder label from Excel to a dox matrix pri. | Excel Discussion (Misc queries) |