In the attached workbook, I am trying to use a vlookup formula to have information for different clients appear in the Service Invoice sheet depending on client name selected in cell a10 (validation list). I am familiar with using the vlookup formula and can get it to work by manually changing the name of the worksheet in the formula, but how do I set it up so as not to have to change client name manually?
I want to be able to select a client in cell A10 and have the information from that clients worksheet appear in invoice.
I hope that is clear.
Thank you for your time and assistance,
Regards,
BigDawg15
Bookmarks