i would use the false 4 th argument as well,then it wiil find an exact match
and your part numbers do not have to be sorted in ascending order......ie
=VLOOKUP(A1,$A$10:$B$500,2,false)


--
paul
remove nospam for email addy!



"Niek Otten" wrote:

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.