Vlookup choosing incorrect row.
I am using the vlookup feature to retrieve a specific dollar amount based on a number on my worksheet. after the 1st 2 total hours are successfully retrieved, vlookup starts returning the answer from the previous row even though the formula has not changed. One thing to note, I do use military time on my sheet and am thinking thats the cause??
Columns used to get the total sum of pay are D,E,G,J & L.
|