Forum Discussion
Create time slot
The values in columns J and K are left-aligned. suggesting that they are text values, not real time values.
Try to convert them to real time values.
And the lookup table in columns N to P should be as in my sample workbook, with NOCHE at the top.
I'd use Data > Text to Columns to split the time ranges in column K into a start time and end time.
Same for the Horario Franja values.
Will each range in column K always fall entirely within one time slot? If so, you can use INDEX/MATCH or XLOOKUP.
See the attached sample.
Yes, it will fall inside the band, I'm trying to apply it in the same way you indicated but it doesn't work the same, I don't know if it's because of the format of the cells.
'm not receiving the correct result
The values in columns J and K are left-aligned. suggesting that they are text values, not real time values.
Try to convert them to real time values.
And the lookup table in columns N to P should be as in my sample workbook, with NOCHE at the top.