Need clarification on why my formula works
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.
|