Multiple Criteria for INDEX/MATCH or VLOOKUP?
I have been defeated while trying to reference another sheet and pull information that matches multiple criteria. I need to pull an Account Number that matches both a Vendor Name and Location Name. Essentially, I want to populate the account numbers for specific locations based on a particular vendor. I cannot add a "Helper Column" to the original sheet that I am referencing. Is there a way to accomplish this using either a VLOOKUP or INDEX/MATCH formula? Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!