Price look-up

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

 

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

 

[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

 

[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

value of cell B1 to $4.00 when cell A1 = A.

 

[Grenville]

David

That worked, many thanks

Gren