Look up for information in a table

C

Cantru

I have a table where I store the inventories data per month for each of my
products. Each product has different models, I have the information of the
estimated production requirements per product/per model/per month. The
general products are in raw one, product A is merged in Cells B1:D1 and
product B is merged in cells E1:F1, the models are in each in cells B2:F2 and
in rows 3 through 15 I have the requirement for each month. In other words
in Cell B3, I have the requirement for product A model 1 for January and in
cell F7 I have the requirements for Product B model 2 for May.

I need to pull this information from another sheet, in which if I request
the month of July I can pull the requirement per product per model in
different cells. How can I do this???

Thanks.
 
C

Cantru

Thanks ice, I do know how to use them, but not well 'cause I haven't been
able to success with them. Here's the think, I have models A, B and C. In
model A, I have models 2", 4" and 5", so as model B and C. So I have 9
different products, each product has different requirement each month. My
question is how can I pull model A-5" for the month of July? If I specify
products (A,B and C) in row one, and models (2", 4" and 5") in row two and
inventories in rows 3 through 15?
Do I need to bee more precise in row one and specify product and model???

Thanks.
And no, the other table is not in the same format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top