formula is not working | Index match

[Mr.Karr]

Experts,

I'm trying to retrieve value from a range where I have date and related values using index match. But it is not retrieving data from another formula (vlook-up value)

Normally this should work flawless. Probably I'm missing something here. Can someone please fix this.

Please refer to the sample file attached.

Thanks,
Kar

 

[Marc L]

Just by removing time from cells, works with only dates …​

 

[bosco_yip]

Try......

C12, formula copy down :

=IFERROR(INDEX($I$2:$I$10,MATCH(TEXT(A12,"mmm/dd/yyyy"),INDEX(TEXT($H$2:$H$10,"mmm/dd/yyyy"),0),0)),"")

Regards
Bosco

 

[Mr.Karr]

@Marc L , I tried that way as well but no results. Please can you share the file where you worked out

 

[Mr.Karr]

thank you @bosco_yip this works like a breeze

 

[Marc L]

@Marc L , I tried that way as well but no results. Please can you share the file where you worked out

Was directly with your attachment ! Just correct dates without time …
​

 

[Chihiro]

Another option.
=INDEX($I$2:$I$10,MATCH(INT(A12),INDEX(INT($H$2:$H$10),,),0))

Date portion can be extracted from DateTime value using INT.

Edit: I'm guessing that the reason Marc's method didn't work for you is that you used NOW() function instead of Today() in your calculation in Column A

 

[Khalid NGO]

Hi to all,

One more:

=SUM(INDEX((INT($H$2:$H$10)=INT(A12))*$I$2:$I$10,))

Regards,