| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup matrix
I have the following matrix. I'm given the values of C and bb
How would i write a macro to get the result? which is 8. aa bb cc A 1 2 3 B 4 5 6 C 7 8 9 D 10 11 12 E 13 14 15 thanks Jack |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup matrix
Jack wrote:
I have the following matrix. I'm given the values of C and bb How would i write a macro to get the result? which is 8. aa bb cc A 1 2 3 B 4 5 6 C 7 8 9 D 10 11 12 E 13 14 15 thanks Jack With your data in A1:B6 here is a worksheet function that will do it. =INDEX(B2:D6,MATCH("C",A2:A6,0),MATCH("bb",B1:D1,0 )) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Matrix Lookup | Excel Discussion (Misc queries) | |||
| Excel Matrix lookup | Excel Discussion (Misc queries) | |||
| lookup in MATRIX | Excel Worksheet Functions | |||
| Lookup in Matrix | Excel Worksheet Functions | |||
Linear Mode
