SOLVED

Lookup values

%3CLINGO-SUB%20id%3D%22lingo-sub-3487883%22%20slang%3D%22en-US%22%3ELookup%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3487883%22%20slang%3D%22en-US%22%3E%3CP%3ENeeding%20help%20with%20lookup%20values.%20Every%20time%20I%20try%20to%20enter%20the%20lookup%20value%20for%20my%20HC%20and%20hours%20worked%20my%20data%20for%20my%20Sum_ev%20(under%20the%20date)%20changes.%20I%20have%20merged%20my%202%20queries%20and%20am%20having%20issues.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3487883%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3488077%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3488077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1349749%22%20target%3D%22_blank%22%3E%40Tmcgrew05%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%20You%20may%20have%20to%20recalculate%20(F9)%20since%20the%20workbook%20refers%20to%20another%20workbook%20that%20I%20obviously%20didn't%20have.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3500562%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3500562%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20worked%20perfectly.%20I%20was%20trying%20to%20do%20that%20formula%20but%20for%20some%20reason%20I%20kept%20missing%20something.%20So%2C%20lets%20say%20I%20wanted%20to%20add%20all%203%20shifts%20together%20for%20that%20day%20to%20get%20for%20the%20day%20as%20a%20whole.%20So%2C%20I%20would%20have%20to%20add%20another%20column%20to%20sheet%202%20for%20a%20daily%20total%20(all%203%20shifts%20combined).%20I've%20tried%20several%20times%20but%20something%20is%20not%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3501269%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3501269%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1349749%22%20target%3D%22_blank%22%3E%40Tmcgrew05%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENew%20version%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3544695%22%20slang%3D%22en-US%22%3ERe%3A%20Lookup%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3544695%22%20slang%3D%22en-US%22%3EI%20want%20to%20thank%20you%20for%20all%20your%20help%20to%20complete%20this%20project.%20My%20boss%20absolutely%20loves%20his%20spreadsheet.%20I%20understand%20the%20Index%20match%20formula%20so%20much%20more.%20Now%20to%20work%20on%20VBA%20codes%20to%20automate%20this%20thing%20to%20do%20a%20save%20as%20and%20rename%20it%20with%20the%20next%20month%20on%20the%20'30'th%20tab.%20Still%20trying%20to%20teach%20myself%20the%20codes.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Needing help with lookup values. Every time I try to enter the lookup value for my HC and hours worked my data for my Sum_ev (under the date) changes. I have merged my 2 queries and am having issues.

4 Replies
best response confirmed by Tmcgrew05 (Occasional Contributor)
Solution

@Tmcgrew05 

See the attached version. You may have to recalculate (F9) since the workbook refers to another workbook that I obviously didn't have.

@Hans Vogelaar 

 

That worked perfectly. I was trying to do that formula but for some reason I kept missing something. So, lets say I wanted to add all 3 shifts together for that day to get for the day as a whole. So, I would have to add another column to sheet 2 for a daily total (all 3 shifts combined). I've tried several times but something is not working.

@Tmcgrew05 

New version attached.

I want to thank you for all your help to complete this project. My boss absolutely loves his spreadsheet. I understand the Index match formula so much more. Now to work on VBA codes to automate this thing to do a save as and rename it with the next month on the '30'th tab. Still trying to teach myself the codes.