# 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.

2. ## Re: Index Match with Date Value

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

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.

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

5. ## Re: Index Match with Date Value

Please confirm that you are still using Excel 2007.

6. ## Re: Index Match with Date Value

Thanks Bo_Ry -
this formula works Exactly.

Thanks a lot

7. ## Re: Index Match with Date Value

Yes .... Still using Excel 2007.

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))),"")

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1