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 to add to this formula =AVERAGEIFS('AC07 Data'!N:N,'AC07 Data'!B:B,B4) to also search the tab "Notes" for the entry in cell D4
Solved by M. C. in 16 mins
search a column for text including specific characters and return sum from those rows in a different column
Solved by K. L. in 18 mins
I need some columns and tables in the excel and also the search engines are making a clear shift in favor of quality
Solved by S. S. in 30 mins
I'm looking to use vlookups to populate cells in a master sheet. I keep running into the issue where I only get 1 value that matches the criteria. Because there are multiple search keys with the same name it only returns the first value. How would i consolidate all the values into one cell separated by a comma.(Using only formulas)
Solved by V. F. in 14 mins
I have a VLOOKUP function that provides a name from a table based on a cell that has part of a name (like search bar). How can I use VLOOKUP again on the name and list the manager which is next to the name in the table?
Solved by E. J. in 19 mins
what search terms could i use to search for help topics relating to array formulas ?
Solved by S. Q. in 19 mins
I need a formula that will search through a spread sheet to find a word in one column and once it finds that word it will search the row for another identical match. If both match, then it will = the answer in another column within the same row as the answer. Two requirement for a specific answer.
Solved by X. J. in 23 mins
I have a set of data that moves dynamically according to a active X Control search box, i need a check box next to each row of the data in which i can check the tick box and extract the specific row into another cell
Solved by C. S. in 22 mins
Is there a way to navigate to other tabs or windows in Excel for Mac (16.11) with a search window open?
Solved by F. Y. in 16 mins
I have a table of phrases of multiple words (e.g. Cupboard Locks or Child Cupboard Lock) and I want to substitute the word 'Cupboard' for another word based on a table of misspellings of that word. To give me multiple new phrases. I have tried using substitute function but it requires me to type in the word / text I wish to substitute in the old_text and new_text fields and I cant use a cell reference instead. I have a huge list of phrases and misspellings of single words and I want to create 1000's of variations to use for search campaigns online where people type the wrong thing in.
Solved by M. Y. in 14 mins