"If"

M

MattBneedsyourhelp

I did a couple of searches but couldn't find what I wanted. Here is th
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 a
the top of my order form

I have the address information in a sheet within this worksheet also.

Any suggestions
 
C

Claus Busch

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top