#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge choosing which location | thisperson1 | Mail Merge | 1 | 06-05-2018 05:59 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 |
Choosing excel vs access for a task | corsair_lancer | Excel | 1 | 10-11-2016 07:59 AM |
Choosing cached address | dexznrl | Outlook | 0 | 09-25-2016 12:51 AM |
choosing monitor on which to play video | PopOnTheAir | PowerPoint | 0 | 02-16-2012 02:07 AM |