How to return a dollar value for a part number entered in a cell

G

Guest

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.
 
B

Biff

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
 
N

Niek Otten

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solution for if x = 1 and Y =2 goto C3 2
Returning value in secocolumn based on selected value in first col 1
enter data in 1 cell and produce a number in another cell 1
Formula For Sorting Part Numbers 1
Input dollar amount into a cell that updates another cell and more 7
lookup? 1
Finding an item in a list & returning a specific value 7
Data entered from list automatically enters number in another cell 4

Top