Resultant value from a Multiple Table

[angumaniraj]

The File contains 6 tables. First 5 Tables named Apple, Orange, Mango, Grapes & Banana and it contains the data of it varieties and its respective cost.

In 6th “Fruit” table, two columns are there. One is ‘Fruit name’ and the second was ‘variety counts’. If I choose any one fruit in a first column using Drop down list, the neighbour cell in the second column(variety counts) should reflect the total variety of the respective fruit.

Please help me to get the solution.

Regards
Angumaniraj

 

[jasonb75]

Your question is a little too vague for anyone to provide you with a detailed solution, from what you ask I think that searching for dependent data validation should provide some useful examples to do what you need.

 

[vmjan02]

@angumaniraj
Please be more clear with your quire

 

[angumaniraj]

Hi Jasonb75 & vmjan02,
Thank you for responding. The Query shown in the attachment. Please check it.

 

[jasonb75]

Maybe

=SUM(INDIRECT("B19"))

 

[angumaniraj]

Maybe

=SUM(INDIRECT("B19"))

Thanks alot. Its working