Forum Discussion
Excel VLookup returns incorrect row
I noticed when using VLookup I'm getting incorrect returns. The answer the formula provides is actually from the column before the correct ansewer. This has recently started happening, and has been w...
It works fine, however I'm finding that the total hours worked in column E , for example, if hours worked are 11:45 hours, it make it 11:80?
Column E contains values in time format h:mm, but column I contains decimal hours.