Populating a cell using Partial cell content from a row but various columns

[firegoff]

I am looking to extract to a cell contents of a cell that I only know how the cell starts? For example, I have a worksheet of 10,000 rows that I am looking for contents of a cell in a row that starts with Manufacturer: * where * is a wildcard depending on the cell.

I want to run a formula (in column A2) to look in the same row (Example Row 2) that populates the cell A2 with the content from a cell that contains the partial text I know "Manufacturer:". It would be on a row by row so I can then copy the formula down in each row. And the cell that contains the partial content may vary by column.

[sktneer]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[firegoff]

Lookup Example.xlsx

Here is the example field. What I am looking for is to populate column A with text from the cell containing "Manufacturer:" (highlighted red). The formula would search the cell horizontally instead of vertically. Additionally, it will not always be in the same column.

[sktneer]

Try this in A2

Please Login or Register  to view this content.

Is this what you are trying to achieve?

[firegoff]

Yes it is. Super Helpful.

[sktneer]

Thanks for the feedback.
If that takes care of you question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.