Excel Magic Trick 520: FIND & SEARCH Functions

[AutoBahnForever]

Is it possible to capture results of a "Find All" for a specific word and transfer it to a new Excel spreadsheet ?

[ExcelIsFun]

@AutoBahnForever , I don't know. Try:

mrexcel [dot] com/forum

[Lucream2]

Hi Mr ExcellsFun I would like to use the find and replace functions to replace data in the same cells from different sheets of the same documents. I don´t want to use the Ctrl "F" function I want a formula to do this for me. Please help me I enjoy your vedios a lot. Thanks in advance.

[ExcelIsFun]

I do not know. I think you would need VBA to do that. Try;

mrexcel[dot]com/forum

[theyangist]

Is there a way to search for any matches from a list of strings inside of groups of text?

In other words, is there a way to pick an array for x in SEARCH(x,y,z), or is there a better method overall for doing it?

I have some lexicographical information that I need to match in two separate arrays.

[ExcelIsFun]

Try this video:

Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

There is no way to do this perfectly becasue you are doing a partial lookup. You also might try posting a detailed question to THE best excel question site:

mrexcel[dot]com/forum

[udanial]

mike hi!

ur videos are awesome,i wanted to ask dat y find didnt give correct answer without adding 1 can u explain a bit?

[ExcelIsFun]

I don't understand your question.

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

I agree: Houdini is an amazing Exceler!!