Get instant live Excel expert help to learn how to use Search function in Excel?

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

search a column which has multiples of the same value and return the minimum value of another column in the array
Solved by I. J. in 26 mins
Hello! I need help with this file. I have a tab on here called "Master Pool". On this tab are four columns I need to extract data from. They are Accessibility Hold 1, Accessibility Hold 2, Accessibility Hold 3, and Accessibility Hold 4. For each row in the sheet, these columns will contain some written out information. This information is separated out, and there are only certain things that will appear in each cell. The information that appears in each cell can be found in the tab "A11Y Tag Placements". There you'll see headers called "Field 1, Field 2, etc." These headers correspond to the "Accessibility 1, 2, etc." fields in the tab "Master Pool". These are basically the options of what can be written in each cell, Here's the issue- for a specific cell, these options may not all appear. In most cases only one or two options appear. What I would like to do is this: I need to search these cells and find specific word strings. For example- I need to search cell X2 in the Master Tab, then I need to see which of the values that could go there are actually there. I need a formula that can search the cell and respond with a whether that specific text is there or not. So in the example, I would like to create a search formula in excel for the word "ASL" in cell X2 that let's me know whether that's there or not.
Solved by T. B. in 11 mins
I need a formula that will search a cell with multiple vales in it (words) and will return whether a specific defined string of text is in there.
Solved by A. Q. in 30 mins
Basically I need to know if there is a way to search for match between two strings where there is many variance in the strings to be matched like wildcards in both strings, additional conditions etc.
Solved by E. H. in 13 mins
I created a macro that performs vlookups in work book #1. I have transferred the macros to a second separate workbook. The problem that I am having is when i run the macros in the second workbook, it is retrieving data from the first workbook, where the macro was created, and placing those values into the second workbook. How can i change the macros to search for the data inside the second workbook?
Solved by O. L. in 17 mins
I have a file i can upload via google drive...I created a macro that performs vlookups in work book #1. I have transferred the macros to a second separate workbook. The problem that I am having is when i run the macros in the second workbook, it is retrieving data from the first workbook, where the macro was created, and placing those values into the second workbook. How can i change the macros to search for the data inside the second workbook?
Solved by T. Y. in 15 mins
i need a formula to look up values in one sheet, that exist in another sheet. I need it to return yes if it does exist and no if it does not. i need another cell to search on the condition that the first cell said yes, and search data similar to the first function.
Solved by D. H. in 24 mins
On my current excel spreadsheet in column C I have it google searching whatever is currently in column A. (its specified for a cell in column A) I want to continue this with the rest of my sheet but do not remember how I was able to make a hyperlink that google searches the contents of any given cell. for example if the hyperlink is in the 32nd row i want a google search link from A32 etc.
Solved by X. A. in 14 mins
I am creating an excel document with all of my movies and I want the information column to be a hyperlink directly going to a google search of column B, however I have two problems 1. I do not want the link to be showing in the spreadsheet but rather the word "information" 2. The link does not currently work an error message pops up that says "Cannot download the information you requested"
Solved by E. E. in 27 mins
I am creating an excel document with all of my movies and I want the information column to be a hyperlink directly going to a google search of column B, however I have two problems 1. The link does not currently work an error message pops up that says "Cannot download the information you requested"
Solved by O. C. in 23 mins