goobers
03-15-2011, 09:58 AM
Hi All,
Normally I come here for VBA assistance, but today I am having difficulty with what I hope is a simple excel function problem.
In the attached workbook I have 2 tabs. The first tab, "Summary", has two columns of data. The second tab, "Data", has a list of text strings.
What I am trying to accomplish is this:
On the "Summary" tab, column B, I want to write a formula that checks the data in Column A against the text strings listed on the "Data" tab. The formula that I would want in Column B would return the text string only if it exists in column A.
For example Cell A2 on the "summary" tab has the words "Con12345 RK-NJ-MA USD$" If you refer to the data tab, you will notice that RK-NJ-MA is listed there. In Cell B2, I want to have the text string identified on the "data" tab returned, so only "RK-NJ-MA"
Keep in mind that the length of the text strings on the "Data" tab are going to vary in my much larger file.
Is there an easy way to do this without VBA? I am preparing a workbook for another team that is not excel savvy.
Many Thanks as always.
-Goobers
Normally I come here for VBA assistance, but today I am having difficulty with what I hope is a simple excel function problem.
In the attached workbook I have 2 tabs. The first tab, "Summary", has two columns of data. The second tab, "Data", has a list of text strings.
What I am trying to accomplish is this:
On the "Summary" tab, column B, I want to write a formula that checks the data in Column A against the text strings listed on the "Data" tab. The formula that I would want in Column B would return the text string only if it exists in column A.
For example Cell A2 on the "summary" tab has the words "Con12345 RK-NJ-MA USD$" If you refer to the data tab, you will notice that RK-NJ-MA is listed there. In Cell B2, I want to have the text string identified on the "data" tab returned, so only "RK-NJ-MA"
Keep in mind that the length of the text strings on the "Data" tab are going to vary in my much larger file.
Is there an easy way to do this without VBA? I am preparing a workbook for another team that is not excel savvy.
Many Thanks as always.
-Goobers