Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Price look-up
Is it possible to automatically enter a numeric value (eg
a price) in a column by entering a code in an adjacent column, referencing a list, in the same way as invoicing software does? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Price look-up
Check out VLOOKUP in help.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Grenville" wrote in message ... Is it possible to automatically enter a numeric value (eg a price) in a column by entering a code in an adjacent column, referencing a list, in the same way as invoicing software does? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Price look-up
Hi
You Could use the VLOOKUP Function Something Like this =VLOOKUP(A1,'Orders'!$A$2:$C$10,2,FALSE) where A1 is the value you are looking up 'Orders'!$A$2:$C$10 is the table you are refrencing 2 is the number of columns along the data is that you Want to lookup FALSE is so the Exact Value HTH Davi -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Price look-up
Thanks Kevin,
Excuse my ignorance but where do I put the code in relation to cells A1 & B1? Does all the text (from "Private..." to "$4.00" go into one cell? Gren -----Original Message----- The following code placed in Worksheet will change the value of cell B1 to $4.00 when cell A1 = A. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Range("$A$1") = "A" Then Range("$B$1") = "$4.00" End Sub Kevin . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Price look-up
David
That worked, many thanks Gren -----Original Message----- Hi You Could use the VLOOKUP Function Something Like this =VLOOKUP(A1,'Orders'!$A$2:$C$10,2,FALSE) where A1 is the value you are looking up 'Orders'!$A$2:$C$10 is the table you are refrencing 2 is the number of columns along the data is that you Want to lookup FALSE is so the Exact Value HTH David --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max Price and Min Price paid for an item - Rephrsed | Excel Worksheet Functions | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
Price List overall price increase | Excel Discussion (Misc queries) | |||
calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) |