| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
VLOOKUP if target appears more than once in a list
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nested IF(OR Vlookup returning zero instead of value in target cel | Excel Worksheet Functions | |||
| vlookup in the row below the target row | Excel Worksheet Functions | |||
| Use Vlookup or similiar function to find the row of the target cel | Excel Discussion (Misc queries) | |||
| Variable VLOOKUP source and target | Excel Worksheet Functions | |||
| Can VLOOKUP deliver the second occurence when target column entri. | Excel Worksheet Functions | |||
Threaded Mode
