Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to return a dollar value for a part number entered in a cell
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Assign a dollar amount to a corresponding number in a range of num | Excel Discussion (Misc queries) | |||
return the column reference number of a function result | Excel Discussion (Misc queries) | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions |