Assume your 3 columns are in A1:C20 (part#, price, in stock), the part number
you want to look up is in cell D1,

=VLOOKUP(D1,$A$1:$C$20,2,0)
=VLOOKUP(D1,$A$1:$C$20,3,0)


"Ken" wrote:

lookup i using three column part #, price, parts in stock. I won't to
lookup
part # and it wil show price and show parts in stock