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!”
Here are some problems that our users have asked and received explanations on
I have a work book with multiple sheets. I need to search all sheets for specific text, and sum the quantities. This is an estimate form with multiple sheet that I am trying to generate a Bill of Material from the data on these multiple sheets.
Solved by K. J. in 19 mins
Find function in colomn A,
Search box in F1
Solved by O. J. in 20 mins
hi, I'd like to search Sheet 2 for a specific name in column x, then copy data in the corresponding row and have it appear in a specific cell in Sheet 1
Solved by V. J. in 13 mins
I need the formula to find where a text string contained in a cell is found in a column. I will be adding more "search terms" all the time. The attached file shows exactly the problem.
Solved by K. Q. in 21 mins
Is there any one who can help me, i have list of some suppliers i want to create drop down list or any other search box , so that in a specific column i wrote some letters and that will show full name.
Solved by G. E. in 22 mins
I need to search a column containing city names to see whether they contain names from a specific list of cities.
Solved by B. F. in 21 mins
How do I create headers that include drop-down menus with search functions? Similar to the file provided
Solved by B. J. in 19 mins
I'm trying to put the search and output lists for the following formula on a separate sheet. But simply selecting the data on that sheet won't work. =IFERROR(INDEX(E$2:E$6, AGGREGATE(15, 6, ROW($1:$6)*SIGN(MATCH("*"&D$2:D$6&"*", $A2, 0)), 1)),"")
Solved by X. W. in 16 mins
i need a formula that will allow me to search using a persons name and give me the team they work with and their role, each name appears multiple times with different teams and different roles. the table is 76 columns and 26 rows
Solved by G. A. in 24 mins
Subject: Search for text within a range of cells in Excel using an IF statement
Body: Right now I have a working formula to search for 2 non-printing characters in a single cell, but I need to search multiple cells on the same row.
What is working: =IF(NOT(ISERROR(SEARCH(" ",$H2))),"Non-printing character",IF(NOT(ISERROR(SEARCH(" ",$H2))),"Non-printing character","OK"))
What I want to do is search $H2:$Q2 and if a non-printing character is contained anywhere within $H2:$Q2, I want cell G2 to display "Non-printing character." If a non-printing character is not found, I want G2 to display "OK."
Any ideas?
Solved by V. Q. in 20 mins