link cells data under certain conditions

[Melnik]

Hello Mr Excell users!

I need help for the following question (this is a breakeven calculation):
I have two worksheets and in 1st one there is a cell where I can choose a specific number (number of itens of products) for example 4. Then, excell in another cells (row) calculate the total amount of sales, income and total costs (all this data is in a table already calculated).
In another worksheet I want to fill some cell with these values (total amount of sales, income and total costs) according to the number of produts I choose in first place automatically. So, what I want is some formula for the 2d worksheet that verifies the number choosed in the first worksheet and then find the correspondent data in the table (total amount of sales, income and total costs) and puts it in the new worsheet dinamically (the data changes if I change the number of itens choosed)

There is someone that can give some help?
Thanks in advance!

Melnik Kuhn

 

[joeyjj]

You may want to try using index and match for example

=index(ColumnOfDataYouWantValueFor , Match(ValueYouWantToCheck,ColumnYouWantToCheck,0)

the 0 at the end provides an exact match for what you are looking for.

You can look up what Index and Match do in the help if my explanation is unclear.

 

[Melnik]

I will try.

Thanks for your prompt answer!

regards,
Melnik