#1
|
|||
|
|||
Vlookup issues using military time
I've created my time sheet, with it all in military time. Its all working fine UNTIL I try to use "Vlookup".. no matter what I try to have looked up, its always returning the previous row's information.. I've checked, rechecked and triplechecked the formula/function but always gives the incorrect return. I have tried creating new table names but same result. Could it be the military time problem? |
#2
|
|||
|
|||
You'll need to post your workbook with your code formulas.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Another Military Time conundrum | cwkotch | Excel | 7 | 02-21-2023 11:04 PM |
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array | EcommDOC | Excel | 7 | 01-22-2018 11:00 AM |
Obtaining a decimal total hours from military time entries (my solution works only in Google Sheets) | gluonman | Excel | 8 | 03-22-2017 08:26 PM |
worksheet compatibility issues using VLOOKUP | gringodegolfo | Excel | 6 | 03-23-2016 08:23 PM |
Military Font in Word | jmdraft | Word | 2 | 03-06-2016 05:31 AM |