R Ram Mher Member Oct 29, 2018 #1 Recharge Validty to be fetched from DATa Base for a person if Transaction time is between the validtity. Please find the attached sheet for necessary support . Thanks in advance for the nice support. Attachments Associated recharge to be fetched.xlsx 9.5 KB · Views: 17
Recharge Validty to be fetched from DATa Base for a person if Transaction time is between the validtity. Please find the attached sheet for necessary support . Thanks in advance for the nice support.
B bosco_yip Excel Ninja Oct 30, 2018 #2 Perhaps, In C3, copied across to D3 and all copied down : =IFERROR(INDEX(I$2:I$7,MATCH(1,INDEX((TRIM($H$2:$H$7)=$B3)*($I$2:$I$7<=$A3)*($J$2:$J$7>=$A3),0),0)),"") Regards Bosco
Perhaps, In C3, copied across to D3 and all copied down : =IFERROR(INDEX(I$2:I$7,MATCH(1,INDEX((TRIM($H$2:$H$7)=$B3)*($I$2:$I$7<=$A3)*($J$2:$J$7>=$A3),0),0)),"") Regards Bosco
R Ram Mher Member Oct 31, 2018 #3 bosco_yip said: Perhaps, In C3, copied across to D3 and all copied down : =IFERROR(INDEX(I$2:I$7,MATCH(1,INDEX((TRIM($H$2:$H$7)=$B3)*($I$2:$I$7<=$A3)*($J$2:$J$7>=$A3),0),0)),"") Regards Bosco Click to expand... Thanks sir it is working fine
bosco_yip said: Perhaps, In C3, copied across to D3 and all copied down : =IFERROR(INDEX(I$2:I$7,MATCH(1,INDEX((TRIM($H$2:$H$7)=$B3)*($I$2:$I$7<=$A3)*($J$2:$J$7>=$A3),0),0)),"") Regards Bosco Click to expand... Thanks sir it is working fine
