Hello - I am trying the vlookup to categorize time into periods. However I am unable to format the lookup value time into hh:mm:ss. As a result I am getting #nA error. Please help me. This is time sensitive for me!!!
Main issue: When the data is imported, we receivetime as a text value (eg. 64539 instead of 06:45:39) also the period range entered are text values. When I convert both into hh:mm:ss it results #n/a error. However if I just type in the time 06:45:39 then it will retrieve the correct result. Please help.
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
=VLOOKUP(A2,B2:C6,2,TRUE) results in #n/A
Main issue: When the data is imported, we receivetime as a text value (eg. 64539 instead of 06:45:39) also the period range entered are text values. When I convert both into hh:mm:ss it results #n/a error. However if I just type in the time 06:45:39 then it will retrieve the correct result. Please help.
Time | Range | Period | |
64856 | 070000 | AM | |
090000 | AM-OFF | ||
110000 | NOON | ||
130000 | PM-OFF | ||
160000 | PM |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
=VLOOKUP(A2,B2:C6,2,TRUE) results in #n/A