I require assistance with multiple criteria VLOOKUP from a reference sheet
I require assistance with multiple criteria VLOOKUP from a reference sheet.
Here is an excerpt from my table(s)
Sheet1: Contains SolArea2, Region, HQRegion. The combination of all these 3 fields should populate a name that is maintained in another sheet (Sheet2)
<>_Approver = SolArea2 + Region + HQRegion
I need H_Approver, L_Approver and E_Approver in 3 separate columns as there as downstream approval workflows.
Sheet2: Contains the same combinations and the Approver column holds the value which should be populated in 'Hiring Manager', 'Learning Manager' and 'Engagement Manager' of Sheet1.
I'm able to achieve this using IF logic, but I think it will be easier maintenance if done in a separate table that can be referenced.
Any inputs are appreciated.
Help Article Resources
Check out the Formula Handbook template!