Finding row number based on text

[Fjeldgaard]

Hi all,

I have tried and tried finding a solution, and maybe there are none. But here goes:

My problem is, that I in one sheet have a lot of data, and in another a lookup sheet. The lookup sheet includes the lookup value that is a short text. In the data sheet there is a column with a big text, and in this text the lookup values are. I now need to find the row in the lookup sheet. How can I do this? If it was the other way around it would be easy.

Fx. the text can be found in Column A in the data sheet, but in each cell the starting point of the short text differentiates.

Do anyone have the solution?

 

[Sufiyan97]

Can you post the data along with some manually typed expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Finding text
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fjeldgaard]

Sorry about the lack of info on cross-post. Did not know that. I will make sure to provide link in the future, or not do cross-post.

Here are to pictures of the sheets

 

[Fjeldgaard]

Finding textThe issue have been solved in another forum. Please find the solution here: