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!