ExcelBanter - lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - lookup (https://www.excelbanter.com/excel-programming/365568-lookup.html)

Ken

lookup

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

JMB

lookup

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

All times are GMT +1. The time now is 12:42 AM.