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.