How to link cells by row number from one worksheet to another

Hi there. I have a spreadsheet that contains client data, name address etc.
Each client data is held on one row and each row is numbered.

What I am trying to do is as follows;
On a new worksheet i have done up an invoice template. How do i type in the client code and the invoice will populate the relevant name, address, money due etc. ( all of this data is kept in the client data per row.

What i am tring to do is by tpying in a client no. it populates the corresponding info contained in the first worksheet.

Hope i am explaing this right. thanks in advance for any help.

Complete noob.

Derek.

You will need to use Vlookup() function. Have a look at how it works in Excel's help files...

e.g. =Vlookup(A1,Sheet2!$A$1:$X$100,2,FALSE)

will look up the item you have in A1 of the active sheet.. it will try to find it in range A1:A100 of Sheet2 tab.. and if it does find it, it will return the corresponding item from the second column in the range, A1:X100, which happens to be column B (B1:B100)...

to get items from columns C, D, E, etc... change the 2 to 3, 4, 5, etc...