Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yep, it works. But I'm not sure I understand exactly HOW.
Here's the formula: =INDEX($T$2:$T$9999,MATCH(1,(A2=$R$2:$R$9999)*(B2= $S$2:$S$9999),0))) I understand the Index part but what's throwing me is the Match. I've read all I can find on Match in the help screens and I can't find anything that deals with the multiplication that is in my Match. I know it's returning the row number for the Index but I don't understand HOW it's doing that. Thanks for any help!! Lauri S. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
countif clarification | Excel Discussion (Misc queries) | |||
If Then Statement Clarification | Excel Discussion (Misc queries) | |||
Beyond VLOOKUP Clarification | Excel Worksheet Functions | |||
If function clarification | Excel Worksheet Functions | |||
If and Dates Clarification | Excel Worksheet Functions |