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

[Max]

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

 

[Hardeep kanwar]

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]

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)

 

[Hardeep kanwar]

Put AA in C1

Copy the formula in D1

And D2 and D3

 

[Hardeep kanwar]

Or See This

http://spreadsheets.google.com/ccc?key=rCeNtKXfuBSrjvoa_exgcRg&hl=en