Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a table like below and want to find the value of the intersect cell
for a given month and product. I want to use the Index and Match functions to find the value of the cell, but I am not familar with the usage and am not able to get Match function to return me the correct row or column location. 1) What did I do wrong? 2) Is there an easier way to find the value of the cell with a matched month name in a row and product name in a column? Thanks! Jan Feb Mar Apr... product a b c d |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Index-Match, with Like or some other Function | Excel Worksheet Functions | |||
Need help with function using INDEX and MATCH. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
index / match function | Excel Worksheet Functions |