Hi
I am trying to use a Vlookup formula from a list of items

THIS IS PAGE 1 (with the list)
A B
1 Sales Qty
2 Apple 3
3 Mango 4
4 Orange 1
5 Apple 2

I want to show in PAGE 2 as follows:
A B
1 Apple 3
2 Apple 2

When I try to vlookup the values for Apple in Page 2 using
=vlookup(A1,page1$A$1:$B$5,2,0), I get "3". But even if I drag the formula
down, I still get 3 as the formula picks up the first value relating to
apple.

Can someone tell me how to use a formula to pick up the "2" in the second
line? Should I be using some other formula other than VLOOKUP?