lookup date for corresponding value

[ganeshm]

Hi...

I am try to use hlookup for getting the corresponding date for the values mentioned. But Getting #NA sign. Kindly let me know what is the right formula to be used to solve this.

Regards,

 

[bosco_yip]

Try,

1] "Start Date", C5 copied down :

=INDEX(E$4:EH$4,MATCH(B5,E5:EH5,0))

2] "End Date", D5 copied down :

=LOOKUP(9^9,E$4:EH$4/(E5:EH5=B5))

Regards
Bosco

 

[pecoflyer]

Perhaps =INDEX($E$4:$EH$4,MATCH($B5,$E$5:$EH$5,0))

 

[ganeshm]

Thank you friends