Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Look up a list of prices
I am trying to find out how to get excel look up prices for approx 200 lines on a quotation from a price list using part numbers and then enter the prices beside each item.
I think this is a job for vlookup but I can't get it to work. Help please |
#2
|
|||
|
|||
Look up a list of prices
Assuming you parts data is set up as follows
A B 1 Part Price 2 A1001 25 3 A1002 26 4 A1003 27 5 A1004 28 6 A1005 29 7 A1006 25 8 A1007 26 9 A1008 27 10 A1009 28 And say you wanted to enter the code in Cell A20 and have the price appear in Cell B20..this is the formula you would put in B20 A20 B20 A1001 =IF(A20="","",VLOOKUP(A20,$A$1:$B$10,2,FALSE)) Result 25 HTH -- _______________________ Naz, London "Numpty" wrote: I am trying to find out how to get excel look up prices for approx 200 lines on a quotation from a price list using part numbers and then enter the prices beside each item. I think this is a job for vlookup but I can't get it to work. Help please -- Numpty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating an invoice with a lookup list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
help with quote program using muliple prices for one quantity {cross post} | Excel Discussion (Misc queries) | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |