Look up data across multiple pages

[jmcgurl]

Hi,

Its been awhile since I've really used excel and I am trying to put together a worksheet that will look across multiple worksheets and pull data. On the master worksheet in cell A1, i have a data validation where i can select a date. then in cell A2 I have a data validation to select a Geo. If I select 7/29/18 & EMEA, then in cells C10 - C30 I would want data to populate with whatever reference is in cell B10 - 30. The catch is that cell B10 - B15 might be one worksheet and B16-B19 might be another worksheet. Here is what that might look like:

B10 C10 (this data is pulled based on selections from A1 & A2)
Cartons Received 10
% to LW -2.5%


Any help would be greatly appreciated.

Thanks

 

[James006]

Hi,

Before getting into details about the size of your workbook ...

Are you after a formula or a macro ...???

 

[jmcgurl]

Hi,

I am after a formula. Thanks for the help.

 

[James006]

Hi,

When it comes to sophisticated formulas... XOR LX has done a magnificent job ...

https://excelxor.com/category/multiple-worksheets/

Hope this will help