Trying to get Vertical Lookup to return more then one value...how?
 

Greetings,

Is there any way to get Vertical Lookup to return more than one value?

Example, its looking for a part number in a list, the part number is listed
twice but VLookup is only returning the first instance of the number.

Thanks
Max

Trying to get Vertical Lookup to return more then one value...how?
 

Try This



A B C D
AA DD AA 1
AA DD DD
BB FFF DD
BB FFF
CC GGGG
CC GGGGG

Spreadsheet Formulas
Cell Formula
D1 {=SMALL(IF($A$1:$A$6=$A$1,ROW($A$1:$A$6)),ROW(1:1) )}
D2 {=INDEX($A$1:$B$6,SMALL(IF($A$1:$A$6=$C$1,ROW($A$1 :$A$6)),ROW(1:1)),2)}
D3 {=INDEX($A$1:$B$6,SMALL(IF($A$1:$A$6=$C$1,ROW($A$1 :$A$6)),ROW(2:2)),2)}
Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!

Hardeep kanwar

"Max" wrote:

Greetings,

Is there any way to get Vertical Lookup to return more than one value?

Example, its looking for a part number in a list, the part number is listed
twice but VLookup is only returning the first instance of the number.

Thanks
Max

Trying to get Vertical Lookup to return more then one value...
 

Thank you for the response, unfortunately I'm not understanding how to use it.

Maybe I can explain my situation by posting the formula I'm currently using:
=VLOOKUP(D2,'[BWD STD.XLS]BWD '!$A:$B,2,0)

Trying to get Vertical Lookup to return more then one value...
 

Put AA in C1

Copy the formula in D1

And D2 and D3

"Max" wrote:

Thank you for the response, unfortunately I'm not understanding how to use it.

Maybe I can explain my situation by posting the formula I'm currently using:
=VLOOKUP(D2,'[BWD STD.XLS]BWD '!$A:$B,2,0)

Trying to get Vertical Lookup to return more then one value...
 

Or See This

http://spreadsheets.google.com/ccc?k...a_exgcRg&hl=en

"Max" wrote:

Thank you for the response, unfortunately I'm not understanding how to use it.

Maybe I can explain my situation by posting the formula I'm currently using:
=VLOOKUP(D2,'[BWD STD.XLS]BWD '!$A:$B,2,0)