Help with INDEX MATCH

Hello I am using below coomand =INDEX([Sup_Res_UR_50A.xlsm]Sheet11!$H$2:$H$51,MATCH(A2&1,[Sup_Res_UR_50A.xlsm]Sheet11!$B$2:$B$51&[Sup_Res_UR_50A.xlsm]Sheet11!$KS$2:$KS$51,0))

Column H having list of dates which I would like to be returned if the condition is met. I am using Cell A2 and 1 from two diff columns. but the column KS could also contain 2 and 3 in place of  1. and I want  the corresponding date to be returned. The above coomand runs well but I am not able to add for values 2 and 3 . 

Could you please help with the command.

Regards,

Prasad

 

 

By: Prasad Rangnekar

Leave a Reply

Your email address will not be published. Required fields are marked *