Excel 2007 : Populate Invoice fields based on Invoice number

Hi everyone,

My first post and I am an excel newbie. I have created a client database in Excel 2007, which I have attached. I wish to populate a client invoice in a separate workbook with client address information, invoice item and price based upon the invoice number in Column B. The invoice numbers simply increase incrementally for each database entry. The information that I wish to use to populate the invoice is contiguous in columns C through I, however the locations that I wish to populate the invoice with are not contiguous (other than the client address lines) I simply wish to use the data in the row corresponding with the invoice number to populate the invoice.

I preferred to create the invoice in a different workbook as it is then simpler to convert this to a pdf document format.

I have attached the client database and a sample invoice. I would be grateful for any assistance that anyone could offer.

Many thanks

I can't identify all your required fields, but this might give you a start.

The problem was that you had not adjusted the formulae to cover your new range of data.

=INDEX([Client_DB.xlsx]Database!$A$2:$H$5000,MATCH($I$16,[Client_DB.xlsx]Database!$B$2:$B$5000,0),1)

The green ranges will now cover up to 4999 invoices, if you think you might need more, increase the 5000 to suit.

The last part of the formula (magenta) is the column number you want the formula to read from.
Therefore in Cell B5 reads from Column 1 (Column A) "Date"
and in Cell I5 reads from Column 8 (Column H) "Price"

In Cell A11 we have used Row(A3) which returns 3, Column 3 (Column C) "Invoice To"
This can be dragged down to A14 and it automatically increments the Column Number.

Hope this helps.