Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell contents
Hi,
I'm trying to create a dynamic invoice - with customer invoice addresses changing when I change the account number [in cell c5]. Can someone advise the easiest [and simplest] way of making this happen? Address is from B4:b7 Thanks for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell contents
One way would be to use a VLookup table on another sheet. Look in the help index for VLOOKUP =vlookup(c5,sheet2!a3:d23,2,0) =vlookup(c5,sheet2!a3:d23,3,0) etc -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike" wrote in message ... Hi, I'm trying to create a dynamic invoice - with customer invoice addresses changing when I change the account number [in cell c5]. Can someone advise the easiest [and simplest] way of making this happen? Address is from B4:b7 Thanks for any help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell contents
Thanks Don - I'll give that a bash!
"Don Guillett" wrote: One way would be to use a VLookup table on another sheet. Look in the help index for VLOOKUP =vlookup(c5,sheet2!a3:d23,2,0) =vlookup(c5,sheet2!a3:d23,3,0) etc -- Don Guillett Microsoft MVP Excel SalesAid Software "Mike" wrote in message ... Hi, I'm trying to create a dynamic invoice - with customer invoice addresses changing when I change the account number [in cell c5]. Can someone advise the easiest [and simplest] way of making this happen? Address is from B4:b7 Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert character at beginning of cell without changing contents | Excel Discussion (Misc queries) | |||
Problem with changing cell contents with $ sign | Excel Worksheet Functions | |||
Changing Cell Contents Colour | Excel Discussion (Misc queries) | |||
Changing the cell contents from decimal to fractional | Excel Worksheet Functions | |||
Changing the Contents of a Cell | Excel Discussion (Misc queries) |