Hi,

Am trying to look up prices that I quoted a client recently to ensure that I
quote the same price. The problem is that the same part number may be
manufactured by more than one company, so I have to quote on those, not just
one.

Vlookup only finds the first one... Example simplified:

Part no. Mfg Price
A-100 ABC 2.00
A-100 XYZ 3.00
A-100 LMN 1.50
L-987 XYZ 0.75
L-987 MNO 0.70
L-987 ABC 0.71

Any ideas??
Thanks

--
Thanks!

Dee