View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LauriS LauriS is offline
external usenet poster
 
Posts: 32
Default 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.