Vlookup Multi Criteria

[Crow_23]

I have a sheet with data as such

DATE Avery10 Norwood20 Shakopee30
8/1/2005 22 7 39
8/2/2005 45 4 65
8/3/2005 4 15 15
8/4/2005 5 7 27
8/5/2005 4 3 65

So A1 contains the date the data was pulled and B1:Q1 contains warehouse names. The numbers represent the amount of orders. I have another sheet (Sheet2) with a control chart on it for stat purposes where column A houses the date. B1 is the plant name (Avery10....) and B2:B contains the amount of orders found in the first sheet. The goal is that if the warehouse name on Sheet2 changes the order amounts for the corresponding date will be updated to reflect the new warehouse. So if for example in Sheet2, Avery10 is in B1 and the order amounts are filled in, if Avery10 is changed to Norwood20, the #'s would reflect. Hopefully this is clear enough. I've searched through previous posts, but am not familiar enough to adapt anything to my situation. Thank you

Ed

 

[NBVC]

Probably, Index/Match will suit your needs.

=Index(Sheet1!$A$1:$Q$100,Match(date,Sheet1!$A$1:$A$100,0),Match(Warehouse,Sheet1!$A$1:$Q$1,0)

Change Sheet1 to actual master sheet name (keep the !)
Change range to suit,
Change date and Warehouse to actual cell references containing that data.

 

[Crow_23]

Thanks, EXACTLY what I was looking for. Hmmm time to put Index and Match on the "to learn" list.

=INDEX(Sheet1!$A$1:$Q$100,MATCH(A2,Sheet1!$A$1:$A$100,0),MATCH($B$1,Sheet1!$A$1:$Q$1,0))