**XCEL FILE ATTACHED**
Question: If I have a workbook with 2 tables; 1 has the data that I want to search and 1 is empty and where I would like the "searched" values output, what lookup formula would I need to use?.
THIS IS THE TABLE I WANT TO SEARCH:
<tbody>
</tbody>
THIS IS THE TABLE I WANT TO OUTPUT TO:
<tbody>
</tbody>
Question: If I have a workbook with 2 tables; 1 has the data that I want to search and 1 is empty and where I would like the "searched" values output, what lookup formula would I need to use?.
- The attached file is a list of companies in one column and the states in which they have locations in the adjacent column
- Each company has multiple states where they have locations (For each company, these are separated by semi-colons For Ex: TX; CA; MA; NY)
- I want to search, for ex, MA and have it output all the different companies that have MA locations
THIS IS THE TABLE I WANT TO SEARCH:
Companies | State Locations | |
Company 1 |
<tbody> </tbody> | |
Company 2 |
<tbody> </tbody> | |
Company 3 |
<tbody> </tbody> | |
Company 4 |
<tbody> </tbody> |
<tbody>
</tbody>
THIS IS THE TABLE I WANT TO OUTPUT TO:
MA | CA | NY | NJ | |||
company name with with MA site would go here |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> | |||||
...and so on |
<tbody> </tbody> |
<tbody>
</tbody>