Formula To Populate Data Based On Criteria

Hi,

I have a data in sheet 1(Location) that that has the name of selected outlets.

In sheet 2(Business Hours), I have the Master list of all outlets with their respective business hours.

I need a formula to match the name of the outlets from sheet 1 to sheet 2 and populate the respective business hours from sheet 2 to sheet 1.

Is this possible ? Appreciate all the help.

I have a cross post here:

http://www.mrexcel.com/forum/showthread.php?t=530485

you can add more Location & just copy the Formula from above :-)