Or, in case you'd like to copy the formula to other cells,

=VLOOKUP(A1,$A$10:$B$500,2,0)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Biff" wrote in message
...
Hi!

Part numbers in the range A10:A500

Corresponding price in the range B10:B500

A1 = part number to search for

B1 = formula:

=VLOOKUP(A1,A10:B500,2,0)

Biff

"free2bjmg" wrote in message
...
Ihave a large number of part numbers with corresponding prices. I would
like
to enter a part number in a cell and have the corresponding price
returned to
the appropriate spot on the worksheet. I am using Excel 2002.