Retrieve data from another sheet

[ghazani7]

Dear all,

I am using MS Excel 2003 and would like to retrive multiple data from another sheet. For example i have client information sheet which is Sheet1 where I have multiple information related to same client like Client Code, Name, Address, Phone, Email etc. Now considering that the Client Code is the only unique information which has entire row for detail information, I want to retrieve data in my second sheet which is Sheet2 by just writing Client Code and all of it's information will be retrived as per my specified columns in Sheet2.

Kindly let me know how can i do this.

Thank you.

[shg]

Look at Help for the VLOOKUP function, and post back if you have problems.

For example, you might put a client number in col A, and in col B and copy across:

=VLOOKUP($A1, Sheet2!A1:Q1000, COLUMN(), False)