HI
I have a table that looks as follows
<tbody>
</tbody>
my goal is to put in a customer # in cell F5 (AA OR BB )
And return underneath all his invoices, and then I can do a VLOOKUP On all the invoice numbers and return the corresponding note
How can i accomplish that
the invoice numbers wouldbe the numbers after the ~
Any help is greatly appreciated
thanks <o></o>
I have a table that looks as follows
customer # and invoice number | note 1 | note 2 |
AA~123 | SAMPLE 1 | SAMPLE 2 |
AA~456 | SAMPLE 3 | SAMPLE 4 |
AA TOTAL | SAMPLE 5 | SAMPLE 6 |
BB~789 | SAMPLE 7 | SAMPLE 8 |
BB~111 | SAMPLE 9 | SAMPLE 10 |
BB TOTAL | SAMPLE 11 | SAMPLE 12 |
<tbody>
</tbody>
my goal is to put in a customer # in cell F5 (AA OR BB )
And return underneath all his invoices, and then I can do a VLOOKUP On all the invoice numbers and return the corresponding note
How can i accomplish that
the invoice numbers wouldbe the numbers after the ~
Any help is greatly appreciated
thanks <o></o>
Last edited: