Pulling Data Based on Certain Criteria
I have a situation where I am trying to pull data from 3+ columns based on a few input fields (city, country, engineer level). We want to output the primary company, secondary company, and third company once this data is inputted.
On my base sheet, I have a City, State, Country, Engineer Level, Primary Company, Secondary Company, Third Company that has all of the information (picture below, there are other columns as well but they can be ignored).
On my input sheet, I have the same columns for the user to input the specific data where we want to then output the primary, secondary, and third company based on what they have inputted (picture below).
Any idea on how to pull the data we want to see? I was thinking a VLOOKUP but I am not sure if that will work for this situation.
Any help here is appreciated!
Help Article Resources
Check out the Formula Handbook template!