Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2022, 06:33 AM
cwkotch cwkotch is offline Vlookup choosing incorrect row. Windows 10 Vlookup choosing incorrect row. Office 2019
Novice
Vlookup choosing incorrect row.
 
Join Date: Oct 2015
Posts: 15
cwkotch is on a distinguished road
Default 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.
Attached Images
File Type: jpg Screenshot 2022-12-09 082326.jpg (110.6 KB, 6 views)
File Type: png Screenshot 2022-12-09 083030.png (30.7 KB, 6 views)
File Type: png Screenshot 2022-12-09 083158.png (27.5 KB, 6 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup choosing incorrect row. 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
Vlookup choosing incorrect row. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft