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

I need a formula that will search for a match of "A4" in another worksheet's row and if it matches, it copies the data over, so all data that matches shows one after another.
Solved by B. L. in 20 mins
I need a formula to search in another sheet for a name of a person and then output the 2 values of the 2 column cells next to it.
Solved by M. D. in 17 mins
so, i want to search a cell for the words "meals" or "breakfast". If it's found, I want to put Yes into the cell where the formula is. If not, no. This is what I have so far... =IF(ISNUMBER(SEARCH(OR("meals", "Breakfast") ,Z54)), "Yes", "No")
Solved by D. U. in 28 mins
Is it possible to associate multiple values with one cell, my issue is that we have a list of compounds which are submitted to a number of experiments, and I want to be able to see which experiments have been done on each compound by running a quick search
Solved by K. H. in 14 mins
I am trying to nest two IF formulas: =IF(D4>0,D4*.3,IF(F4>5,(F4-5)*45),0). Or, stated in English, If D4 is more than 0, then D4 times 0.3, if not, then if F4 is more than 5, then(F4 minus 5) times 45, if not then 0. Also, I have subscribed to Office 365 and a Google search told me that I should be able to nest IF Statements using the function IFS, but I don't have that function.
Solved by B. W. in 19 mins
i have three worksheets, year 1, year 2 year 3 in once excel file and need to be able to search these three sheets for various content and do analysis on the data, all three sheets are set up exactly the same, can you help me create pivot tables or whatever you think is best
Solved by I. J. in 30 mins
I need to sum monthly data into an annual summary sheet. I think I have to use vlookup and the column to search is E and the data to sum is in columns K:AN from each of the monthly sheets. Can you help me set that up?
Solved by F. Q. in 16 mins
In a field within my database, there should be only one value. For maintenance purposes, I want to find those multi value fields and update to the correct, one value. When using Excel 2010 to search for those multi values within my database field, is it possible to sort the pivot table by the number of occurrences within the record instead of the number of rows for each record? Please let me know if there is a more logical approach to obtain the information; i.e., sort spreadsheet instead of pivot the spreadsheet.
Solved by X. L. in 20 mins
I am just changing the reference sheet where the information needs to search and I am not getting result. the original formula was: =VLOOKUP(C225,'Jedox txt'!B:B,1,0) was changed to: =VLOOKUP(C225,'Jedox_data'!B:B,1,0) I checked format of cells and looks like same but I am not getting the result. What can be wrong?
Solved by M. U. in 11 mins
I need a formula to search a cell on one page and pull information off of another page.
Solved by S. H. in 26 mins