Hello,
I have two worksheets.
The first has a long list of text strings containing construction related entries like WATER SOFTENERS WITH BRINE TANK or DOMESTIC WATER SOFTENERS for example. There is a unique ID associated with each string in another cell.
The second sheet has a long list of common construction terms, like SOFTENERS for example.
Is there a way to match the term SOFTENERS to each of the two hits on Sheet 1 and return both of their unique IDs?
I have been working with this formula in Sheet 2:
Where A128 is the keyword I'm using to search, index_con_lookup is the range with the unique ID (Sheet 1) and match_col is just the column of descriptions from Sheet 1.
But it produces erratic results and changing the MATCH TYPE produces less hits. I've been trying to rearrange the formula various ways but can have it produce accurate results for even the first hit. Subsequent hits I figure I could make a second, third and fourth column that drops out the findings in the column before it. Then I would concatenate all the unique IDs to one cell and that's it.
I have been staring at VB tutorials and codes for hours and I can't make heads or tails of it that way.
Sorry so long. Any thoughts?
I have two worksheets.
The first has a long list of text strings containing construction related entries like WATER SOFTENERS WITH BRINE TANK or DOMESTIC WATER SOFTENERS for example. There is a unique ID associated with each string in another cell.
The second sheet has a long list of common construction terms, like SOFTENERS for example.
Is there a way to match the term SOFTENERS to each of the two hits on Sheet 1 and return both of their unique IDs?
I have been working with this formula in Sheet 2:
Code:
=IF(A128="","",INDEX(index_con_lookup, MATCH(A128,match_col),3))But it produces erratic results and changing the MATCH TYPE produces less hits. I've been trying to rearrange the formula various ways but can have it produce accurate results for even the first hit. Subsequent hits I figure I could make a second, third and fourth column that drops out the findings in the column before it. Then I would concatenate all the unique IDs to one cell and that's it.
I have been staring at VB tutorials and codes for hours and I can't make heads or tails of it that way.
Sorry so long. Any thoughts?
