Sep 17 2019 04:13 PM
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?