Workbook_Test.xlsxHey guys, I'm relatively new to excel, and I'm hoping you can help me out.
I have a form that I use to ship out to many companies, and was wondering if there was a way to not have to find and type out an address every time. Basically, I have a list of all the company names and addresses on Sheet 2, and the main form on Sheet 1. Each of the businesses have a special 3 letter code. I want to be able to type in the 3 letter code on Sheet 1, cell C8, and have the corresponding address appear in C9-C12.
On Sheet 2, I have the businesses listed as such:
A1 | A2 | A3 | A4 | A5
Code | Company Name | Address | City, State | Zip/Postal code
Is there a formula that would do this?
Bookmarks