Linking Cells...
 

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!


--
chrizty22
------------------------------------------------------------------------
chrizty22's Profile: http://www.excelforum.com/member.php...o&userid=32314
View this thread: http://www.excelforum.com/showthread...hreadid=520688

Linking Cells...
 

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

Linking Cells...
 

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.

"chrizty22" wrote:


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!


--
chrizty22
------------------------------------------------------------------------
chrizty22's Profile: http://www.excelforum.com/member.php...o&userid=32314
View this thread: http://www.excelforum.com/showthread...hreadid=520688