Linking Cells...

C

chrizty22

Does anyone know how to link cells in the same worksheet? For example, I
am typing up orders. Every time I put in 4 x 6 (size) in one column, I
want the price to automatically appear in the price column, $8.95. I
just want to be able to program the correlating text/numbers. Every
time I check the Delivery column, I want 5.00 to appear in another
column. How can I program this? Thanks for any help!
 
D

Dave O

VLOOKUP will perform the correlation of text to numbers. When you say
"check the delivery column", do you have a checkbox in that column?
Assuming you do, you might use and IF statement, something along the
lines of =IF(D1=TRUE,5,0).
 
K

kassie

Your details are sketchy, but VLOOKUP should do the trick for you. Set up a
list of items you want looked up, eg A100:D150. If you type your description
in say a5, and you want the cost in D5, then in D5
enter+VLOOKUP(B5,A100:D150,4,FALSE) The 4 being the number of columns offset
from A, where the cost is.
 
Top