Index Match with Date Value

1. Index Match with Date Value

Hi Friends

I am facing a trouble in Index match with date value,
here with enclose the sample file.  Register To Reply

2. Re: Index Match with Date Value

You need to explain what you want. A non-working formula tells us nothing.  Register To Reply

3. Re: Index Match with Date Value

Glenn,

I need a suitable formula in column K, specified Date in Column I,
data pull from Range A2 to D133.  Register To Reply

4. Re: Index Match with Date Value

Maybe try at K2

=IFERROR(INDEX(CuID,SMALL(IF(\$B\$2:\$B\$133=I2,ROW(\$B\$2:\$B\$133)-ROW(\$B\$1)),COUNTIFS(I\$2:I2,I2))),"")

confirm by Ctrl+Shift+Enter  Register To Reply

5. Re: Index Match with Date Value

Please confirm that you are still using Excel 2007.  Register To Reply

6. Re: Index Match with Date Value

Thanks Bo_Ry -
this formula works Exactly.

Thanks a lot  Register To Reply

7. Re: Index Match with Date Value

Yes .... Still using Excel 2007.  Register To Reply

8. Re: Index Match with Date Value

If interested, here is a non-array version that works with Excel 2007:

=IFERROR(INDEX(\$D:\$D,SMALL(INDEX((\$B\$2:\$B\$133<>I2)*10^10+ROW(\$B\$2:\$B\$133),0),COUNTIFS(I\$2:I2,I2))),"")  Register To Reply