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?

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?

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

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
.

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/

.