XL help required

Solved/Closed
shailendra_arya2006 Posts 3 Registration date Tuesday July 26, 2011 Status Member Last seen October 28, 2011 - Jul 27, 2011 at 04:37 PM
 shail - Aug 7, 2011 at 10:21 AM
Hello,
I need a help for one of my workbook.
I have a workbook with a sheet name master and contains the below data:

Nokia LG MOTOROLA SONY HTC
DELHI 22 32 12 12 33
Mumbai 11 22 33 66 65
Guwahati 22 32 12 12 33
shimla 45 66 89 102 45
pune 47 85 92 18 11
bareilly 22 32 12 12 33

I have three more sheets in that with name shonu,mohan and raj.

Raj Data:
Nokia LG
DELHI 22 32
shimla 45 66
bareilly 22 32

Shonu data:
MOTOROLA SONY HTC
Guwahati 12 12 33
pune 92 18 11
Mumbai 12 12 33

Shonu data:
LG MOTOROLA
DELHI 32 12
shimla 66 89
bareilly 32 12

I want a formula that picks the value from sheet 1 to other three depending on the store and phone model.The formula should check store and phone model simultaneously and then display the quantity. In case i change the headers in sheet shonu to Motorola LG from Motorola LG then qty should be changed automatically.



I really need this help urgently and will be really thankful if anyone suggest me the required formula.



Thousands of thanks in Advance.


Regards
Shail

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 28, 2011 at 03:44 PM
Could you upload a sample excel file with some sample data on some shared site and post back the link. In the file if you could show how the data is and how you would like it to be
0
Hi,,thanks for the reply... can u give me ur email id so that i can send a sample file.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 31, 2011 at 08:16 AM
Thanks a no no here. You can upload a file to a shared site and then post back the link to the file here.
0
http://shailendraisking.hpage.com/

please see the above link..this will redirect you to my site.Under main menu,find the introduction tab and click there. you will find XL Help required,clik on it and file will be open.


Thanks
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 1, 2011 at 09:57 PM
Each time you paste data, would the previous data (all rows) in the other sheets will be updated ? or only few rows will be updated and rest should be left alone ?
0
this sheet is to be updated weekly,so data has to be updated in all sheets whenever there will be a change in master...
0