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 have a list of peoples names and information in 4 columns that is on one sheet of my workbook. and i want for all my other sheets to always search these people name sheet to automatically add them to the other sheets.
Solved by I. L. in 15 mins
I hope you can help. I'm trying to create a formula (in cell C9) of my spreadsheet shown above whereby I can search all countries in the header row (C1:I1) and then add the total number of times that 'Pass' is entered in the cells beneath. The result should equal 6 for the UK. The formula I have used (as shown on the spreadsheet) only seems to count the first columns of cells which has UK in the header.
Solved by O. F. in 25 mins
My sheet has donors details in and up to 30000 lines of data. I want to count the donations made for each individual person. Some make a few donations of a few pounds some make many donations of a few pounds, some make lots of donations of more money - so there is no set quantity. I have sorted by postcode - I thought if i could search down the post code, whilst ever a match - add the amount donated to a cell - when the field changes - total the cell. Next Would that work? Hope you can help us.
Solved by O. S. in 19 mins
I am creating a dynamic search box to navigate my inventory database. However I must be able to search by a few different methods. SAP Number, Basic Description, storage location, MPN, ISD and each one of these categories are in different columns. The issue I am having is when i search do a search by basic description there is thousands of duplicates of the same search terms even though only 1 version exists in the database.. can you help?
Solved by Z. C. in 24 mins
What formula do I use to search for a particular row for an event and when the criteria is found, calculate items in the column below? Example: Row 5 contains the sales price of a building ($1,500,000) in a cell between Columns M and X; the calculation needs to find the cell containing $1,500,000 and then calculate the the NOI contained in the Rows 20 - 30 in the same Column as the cell containing $1,500,000.
Solved by I. B. in 25 mins
I have an excel workbook with 30+ sheets in it. I want to create another sheet labeled "search" in which there is a search box. When I type data into the search box, I would like it to tell me which tab the data is located. Thank you.
Solved by K. U. in 23 mins
I have a Userform that is supposed to take the input from a barcode scanner and then search through the previous logged items to find the cell that matches the number that the barcode scanner output. Right now I am having issues getting the userform number to match the list that is present in the whole sheet, I think it has to do with defining the userform value as a string or number, but I cannot figure out how to adjust that. I would also at some point like to make the Userform input automatic, so that as soon as you scan the barcode with the scanner, it will search and log the required information.
Solved by X. H. in 21 mins
I have a spread sheet that I 6 materials on. There are about 400 rows and each row has one of the 6 materials listed in a column. Each material has an amount listed in a different column. I need to do a search for all the materials that match and then sum up the amounts used of each
Solved by E. E. in 17 mins
I need a formula that will search other sheets for two values together and then total in a cell. I want it to search for the town, the EWC code and then total the tonnes. Please see
Solved by X. A. in 17 mins
I am trying to do the following function but with 4 ifs/isnumber sections: =IF(ISNUMBER(SEARCH("Display",J3)),"GDN",IF(ISNUMBER(SEARCH("Search",J3)),"GSN"))
Solved by B. Y. in 15 mins