Finding Min/Max for Dynamic Date Range

Hi Martin--

I plugged your solution in and it worked as promised. Can you help me understand how it works? I'm familiar with both INDEX(MATCH) and LOOKUP, but I'm left scratching my head as to why the INDEX(MATCH) returns the smallest date and the LOOKUP returns the largest.

Any insights into how that works?

Thanks!

Originally Posted by martindwilson

B7 =index($b$1:$aP$1,match(a7,$b$2:$aP$2,0))
c7 =LOOKUP(A7,$B$2:$AP$2,$B$1:$AP$1)

Hi Martin--

I plugged your solution in and it worked as promised. Can you help me understand how it works? I'm familiar with both INDEX(MATCH) and LOOKUP, but I'm left scratching my head as to why the INDEX(MATCH) returns the smallest date and the LOOKUP returns the largest.

Any insights into how that works?

Thanks!