Hi is it possible to index match but ignore colon in time ?
Have added screen shot for better understanding
Thanks
Have added screen shot for better understanding
Thanks
Cell Formulas | ||
---|---|---|
Range | Formula | |
F1:F4 | F1 | =IFERROR(INDEX($G$1:$G$999,MATCH(E1,SUBSTITUTE($D$1:$D$999,":",""),0)),999) |