Two cell validation (VLOOKUP,MATCH,INDEX)

Copper Contributor

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?

0 Replies