Two cell validation (VLOOKUP,MATCH,INDEX)

%3CLINGO-SUB%20id%3D%22lingo-sub-860054%22%20slang%3D%22en-US%22%3ETwo%20cell%20validation%20(VLOOKUP%2CMATCH%2CINDEX)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860054%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20assistance%20with%20a%20lookup%3A%3C%2FP%3E%3CP%3EId%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BName%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Accounts%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BOrders%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2018%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2019%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2018%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%202019%3C%2FP%3E%3CP%3E1%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BJames%20Smith%3C%2FP%3E%3CP%3E3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BJane%20Doe%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20workbooks%20that%20contain%20the%20counts%20for%202018%20and%202019%2C%20my%20first%20step%20is%20to%20find%20the%20name%20and%20return%20the%20count%3C%2FP%3E%3CP%3EVLOOKUP(B3%2C%20'2018sheet2'!%24A2%3A%24D50000%2C3%2C0)%3C%2FP%3E%3CP%3EHere's%20the%20catch%20I%20need%20to%20make%20sure%20the%20value%20being%20pulled%20is%20for%20the%20correct%20category%20(Accounts%20or%20Orders)%20I%20user%20D1%2FF1%20headers%20as%20the%20category%20this%20matches%20a%20column%20in%20the%20WB.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20this%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-860054%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I need assistance with a lookup:

Id             Name                      Accounts                       Orders

                                       2018         2019                 2018          2019

1         James Smith

3         Jane Doe

 

I have 2 workbooks that contain the counts for 2018 and 2019, my first step is to find the name and return the count

VLOOKUP(B3, '2018sheet2'!$A2:$D50000,3,0)

Here's the catch I need to make sure the value being pulled is for the correct category (Accounts or Orders) I user D1/F1 headers as the category this matches a column in the WB.

 

How can this be done?