View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cropgrl23 cropgrl23 is offline
external usenet poster
 
Posts: 1
Default Match 2 columns + corresponding date?

I've managed to match two columns (B + K) and return the value in a third
column (D) using the formula below.

=INDEX(B2:L1204,MATCH(K2,B2:B1204,0),3)

Here's where I'm stuck... there are multiple matches to some items in
Columns B and K. I only want to return the value of the B/K match that also
has a matching date. Columns C and L contain the dates.

I'm driving myself nuts trying to figure this out! Thanks to anyone who can
provide a suggestion!