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

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

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)

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)

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)