Customer ID in Invoices

[Seton]

Hello I am making a invoice and I got the date working and also the next invoice number but I cant get the customer ID to work. I want to auto fill the customers in my new invoice. Can anyone help.

Thanks In advance

 

[BigBeachBananas]

Can you show an example? I'm not understanding what you're asking.

 

[Seton]

hello I think i need a customer data sheet. I want to give my customer a id number so when i put lets say 3 in the customer id field it will populate the bill to columes

 

[BigBeachBananas]

Ok. What does your data look like? Please share everything related.

 

[Seton]

Ok. What does your data look like? Please share everything related.

so on the left i started a customer list and on the right is my invoice. I want to input a number under customer ID on the spreed sheet and it will populate the bill to with the customers name address and so on

 

[BigBeachBananas]

In the customer list, insert a new column called CustomerID. Assign the customer ID however you like.

On the bill sheet, insert this formula in cell A10

=VLOOKUP($D$5, customerID!A:G,2,FALSE)

In cell A11, change the formula to 3

=VLOOKUP($D$5, customerID!A:G,3,FALSE)

In cell A12, change the formula to 4 and so on...

 

[Seton]

Hello this is what i got

 

[BigBeachBananas]

Your customer ID on the invoice is empty.

Note: You misspelled "Invoice" in the red.