Does this mean we can not use the vlookup to fill all data, we have to design
a sheet without the vlookup?

"dk" wrote:

We have invoices by company name how can we select all the invoices with 1
vlookup ex:row a1 A10 A13 A17 all are for (john)
all of them are for for the same customer we want to have several lines on
invoice for each invoice automatically filled itemized with vlookup, or what
is if we need only invoice from a10?