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

Hello, please would you be able to assist with what is incorrect in this forumla? =IF(ISNUMBER(SEARCH("meeting",K98573,"Meeting",IF((ISNUMBER(SEARCH("management",K98573,"Management",IF((ISNUMBER(SEARCH("admin",K98573,"ADMIN",IF((ISNUMBER(SEARCH("development",K98573,"Development",IF((ISNUMBER(SEARCH("prep",K98573,"Prep",IF((ISNUMBER(SEARCH("office",K98573,"Office",""))))))
Solved by B. C. in 27 mins
i Need to create an automation to search an entire row and fins some data to out put.
Solved by M. H. in 12 mins
I have a spreadsheet where I have a list of codes. On another sheet in the same workbook I have the same codes in one column and their descriptions in another column. I would like a formula to take the code on my one sheet search for it on the other sheet and then give me the description that is in the column next to it.
Solved by D. J. in 11 mins
I need to search cells for text and display the appropriate column value
Solved by Z. S. in 22 mins
hi im try to set up a lookup search from a drop down box
Solved by A. F. in 19 mins
Hi, can u please help me how to use a formula to search a date in specific column and display that entire row in other sheet.
Solved by K. Q. in 21 mins
Hello How can we search Specific rows in excel which contains the data selecting through alphabets in drop down list
Solved by E. D. in 26 mins
This is the formula you provided to extract the last word form a text string to another cell: =MID(A1,SEARCH("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,LEN(A1)) The problem is that I need it to extract (remove) the word form the end of the text string and insert it into the new cell. This is not happening with this formula.
Solved by T. F. in 28 mins
We use excel to keep track of our invoices throughout the year, and each invoices is coded to a specific "account" Now each of these accounts is assigned its own seperate budget. I have the seperate budget sheets built out and they work great for us. However, I have to manually enter the Invoice amount after I filter the spreadsheet by code and date. Is there a formula(Like a Vlookup) to where when we enter the invoice in the spreadsheet it populates? For example if I were to enter an invoice into the spreadsheet and the code was 0750, is there a way for that code to search and populate the budget on a month to month basis
Solved by O. Y. in 25 mins
I have a large .xlsx file with text data that I would like to be able to search with various terms. The find function works for 1 word or 2 words beside each other but I need a way to search for 2 or 3 different words throughout a cell that may not be beside each other, throughout the sheet. Thank you.
Solved by Z. Q. in 27 mins