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