"If"
I did a couple of searches but couldn't find what I wanted. Here is the question:
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 I have the address information in a sheet within this worksheet also. Any suggestions. |
"If"
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 |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com