Lookup Values in another sheet and bring back data based on city name
I have a master sheet and have created a new spreadsheet for a project. I am wanting to see if it is possible to look at the city name from my my 1st sheet (ORIGINAL SHIP TO LOCATION) and bring data back from the master location sheet in a column titled STREET?
1st sheet name = MASTER Locations
2nd sheet name = IRE MASTER ORDERS
Does anyone know how to accomplish this?
Help Article Resources
Check out the Formula Handbook template!