Hi Matt,

Am Tue, 23 Apr 2013 21:59:20 +0100 schrieb MattBneedsyourhelp:

I have a worksheet for orders. What formula do I need to populate Name,
Address etc cells in my order form based on the Client Number I input at
the top of my order form

what you need is VLOOKUP or a INDEX/MATCH combination


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2