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
Thanks In advance
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 onOk. What does your data look like? Please share everything related.
=VLOOKUP($D$5, customerID!A:G,2,FALSE)
=VLOOKUP($D$5, customerID!A:G,3,FALSE)