Price look-up

G

Grenville

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

Bob Phillips

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)
 
D

DSC

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
 
G

Grenville

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
Click to expand...
value of cell B1 to $4.00 when cell A1 = A.
 
Top