Home

Formula to look up 2 values and return 3rd value

%3CLINGO-SUB%20id%3D%22lingo-sub-751629%22%20slang%3D%22en-US%22%3EFormula%20to%20look%20up%202%20values%20and%20return%203rd%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751629%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20that%20contains%20timesheet%20entries%20for%20employees%20on%20certain%20dates.%26nbsp%3B%20I%20have%20another%20workbook%20that%20contains%20the%20job%20the%20employee%20was%20scheduled%20to%20work%20on%20certain%20dates.%26nbsp%3B%20I%20need%20a%20lookup%26nbsp%3B%20formula%20that%20matches%20the%20employee%20ID%20and%20date%20and%20then%20returns%20the%20scheduled%20job.%3C%2FP%3E%3CP%3EI%20know%20how%20to%20use%20vlookup%20to%20lookup%20the%20employee%20and%20return%20the%20scheduled%20job%20but%20not%20how%20to%20incorporate%20the%20date%20factor%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-751629%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751667%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20look%20up%202%20values%20and%20return%203rd%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751667%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375223%22%20target%3D%22_blank%22%3E%40melanie2451%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20no%20scheduled%20jobs%20in%20your%20attached%20files.%20Please%20ensure%20that%20such%20jobs%20are%20indicated%20therein%2C%20then%20attach%20your%20files%20again.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751764%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20look%20up%202%20values%20and%20return%203rd%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375223%22%20target%3D%22_blank%22%3E%40melanie2451%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20the%20attached%20files%20just%20for%20the%20understanding%20purpose%20that%20how%20to%20incorporate%20date%20factor%20in%20vlookup.%20You%20may%20rearrange%20the%20columns%20accordingly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754092%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20look%20up%202%20values%20and%20return%203rd%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20assistance%2C%20it's%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E
melanie2451
New Contributor

I have a workbook that contains timesheet entries for employees on certain dates.  I have another workbook that contains the job the employee was scheduled to work on certain dates.  I need a lookup  formula that matches the employee ID and date and then returns the scheduled job.

I know how to use vlookup to lookup the employee and return the scheduled job but not how to incorporate the date factor 

3 Replies

@melanie2451 

I see no scheduled jobs in your attached files. Please ensure that such jobs are indicated therein, then attach your files again. 

@melanie2451 

Please refer the attached files just for the understanding purpose that how to incorporate date factor in vlookup. You may rearrange the columns accordingly.

@tauqeeracma 

Thank you for your assistance, it's greatly appreciated.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies