DH Templates

Excel Formula for an invoice?

I am trying to create an invoice using "Numbers 09" (iWork). I have sheet 1 which is the invoice template and sheet 2 which is a list of all my clients. So, in sheet 2, row 1 is a header. A2 = Client id, B2 is the clients name, and C2 is the first line of the address. D2,E2,F2 & G2 is the rest of the address including the postcode etc. In sheet one, on the invoice I have a cell called "Client id" and I would like populate the name and address cells based on what is inserted here. So Client id 1 would use the info in the row associated with it in sheet 2. Any help you can give would be much appreciated. email me at scottwchristie @hotmail.com and i can send a screen shot if this would help. Sorry, I said excel in the question but I am using Numbers 09 for Mac.

Public Comments

1. Your basic question states 'Excel', but in the body your refer 'Numbers 09'. The following is the VLOOKUP method for Excel. Assuming you enter the client ID in A1 of Sheet1, and you have 30 clients, then to return the client's Name in B1 of Sheet1 enter: =VLOOKUP(A1,Sheet2!$A$:$G$31,2,FALSE) For the first line of the address in C1, enter: =VLOOKUP(A1,Sheet2!$A$:$G$31,3,FALSE) For the next line of the address in D1, enter: =VLOOKUP(A1,Sheet2!$A$:$G$31,4,FALSE) etc....