Vlookup ........... i think .... please help

[JohnDouglas]

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 55% 25% 60% 22%
Tokyo Available 3 6 8 9
0 Eaten 2 3 4 9
Tokyo Total 5 9 12 18
Tokyo Percentage Eaten 40% 33% 33% 50%
New York Available 1 1 4 6
0 Eaten 6 7 4 2
New York Total 7 8 8 8
New York Percentage Eaten 86% 88% 50% 25%

 

[JohnDouglas]

another attempt to post the data:

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 55% 25% 60% 22%
Tokyo Available 3 6 8 9
0 Eaten 2 3 4 9
Tokyo Total 5 9 12 18
Tokyo Percentage Eaten 40% 33% 33% 50%
New York Available 1 1 4 6
0 Eaten 6 7 4 2
New York Total 7 8 8 8
New York Percentage Eaten 86% 88% 50% 25%

 

[JohnDouglas]

edited for size

 

[JohnDouglas]

edited for size

 

[JohnDouglas]

edited for size

 

[Zack Barresse]

Please continue here: http://www.mrexcel.com/board2/viewtopic.php?t=130099