JohnDouglas
Board Regular
- Joined
- Jan 5, 2005
- Messages
- 239
hi
i'm hoping you guys can help with this. i've realised that i need vlookup formulas for this.
what i need is that when in say sheet1 some types the city in a1 and the fruit in b1, in c1 the value of available pieces of fruit will be returned for that city. is it possible to do something like that?
i've pasted the data in below. how would i get excel to return the number of pears available in london?
thank you very much for you help. hopefully the data will show correctly in this post so that it can be cut and pasted should you need to.
thanks again
City ; status ; Pears ; Apples ; Bananas ; Oranges ;
London ; Available ; 10 ; 6 ; 4 ; 7 ;
0 ; Eaten ; 12 ; 2 ; 6 ; 2 ;
London Total ; ; 22 ; 8 ; 10 ; 9 ;
London Percentage Eaten ; ; 0.545454545 ; 0.25 ; 0.6 ; 0.222222222 ;
Tokyo ; Available ; 3 ; 6 ; 8 ; 9 ;
0 ; Eaten ; 2 ; 3 ; 4 ; 9 ;
Tokyo Total ; ; 5 ; 9 ; 12 ; 18 ;
Tokyo Percentage Eaten ; ; 0.4 ; 0.333333333 ; 0.333333333 ; 0.5 ;
New York ; Available ; 1 ; 1 ; 4 ; 6 ;
0 ; Eaten ; 6 ; 7 ; 4 ; 2 ;
New York Total ; ; 7 ; 8 ; 8 ; 8 ;
New York Percentage Eaten ; ; 0.857142857 ; 0.875 ; 0.5 ; 0.25 ;
i'm hoping you guys can help with this. i've realised that i need vlookup formulas for this.
what i need is that when in say sheet1 some types the city in a1 and the fruit in b1, in c1 the value of available pieces of fruit will be returned for that city. is it possible to do something like that?
i've pasted the data in below. how would i get excel to return the number of pears available in london?
thank you very much for you help. hopefully the data will show correctly in this post so that it can be cut and pasted should you need to.
thanks again
City ; status ; Pears ; Apples ; Bananas ; Oranges ;
London ; Available ; 10 ; 6 ; 4 ; 7 ;
0 ; Eaten ; 12 ; 2 ; 6 ; 2 ;
London Total ; ; 22 ; 8 ; 10 ; 9 ;
London Percentage Eaten ; ; 0.545454545 ; 0.25 ; 0.6 ; 0.222222222 ;
Tokyo ; Available ; 3 ; 6 ; 8 ; 9 ;
0 ; Eaten ; 2 ; 3 ; 4 ; 9 ;
Tokyo Total ; ; 5 ; 9 ; 12 ; 18 ;
Tokyo Percentage Eaten ; ; 0.4 ; 0.333333333 ; 0.333333333 ; 0.5 ;
New York ; Available ; 1 ; 1 ; 4 ; 6 ;
0 ; Eaten ; 6 ; 7 ; 4 ; 2 ;
New York Total ; ; 7 ; 8 ; 8 ; 8 ;
New York Percentage Eaten ; ; 0.857142857 ; 0.875 ; 0.5 ; 0.25 ;