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
Hello. I am trying to add information from one spreadsheet onto another. The spreadsheet I am adding to contains part numbers, descriptions and prices. I want to add weights for each part number from another spreadsheet that contains part numbers with weights. My problem is that the part number lists are not exactly the same. The source list has more part numbers than the destination list. I tried a LOOKUP function to search the imported list with the weights hoping to return the weight to a column that correlates to the list with the prices.
Is there a different function or a different syntax I can use to accomplish this?
Solved by M. S. in 15 mins
I need a formula that will search for a match in a range of cells then when it finds the row in which the match is finds, enters "HOLD" in the column of that match number
Solved by I. J. in 29 mins
I need a formula to return the middle name out of a string of data, using text function excel. Cannot find the right combinations of Mid and search to solve.
Solved by C. Y. in 16 mins
Hello. I am trying to add information from one spreadsheet onto another. The spreadsheet I am adding to contains part numbers, descriptions and prices. I want to add weights for each part number from another spreadsheet that contains part numbers with weights. My problem is that the part number lists are not exactly the same. The source list has more part numbers than the destination list. I tried a LOOKUP function to search the imported list with the weights hoping to return the weight to a column that correlates to the list with the prices. Is there a different function or a different syntax I can use to accomplish this
Solved by Z. C. in 26 mins
i want to enter data on sheet1 and it search the other sheets to find matching data. it then tells me which sheet it on
Solved by A. H. in 25 mins
how do search for text that is formatted white font color and change it to orange
Solved by D. A. in 29 mins
can you do a find function for the number 3 only and have search results not return 30
Solved by X. J. in 20 mins
Trying to search column cells for duplicates based on first 7 characters. Then highlight the duplicates.
Solved by K. S. in 14 mins
I need to filter out a number of numbered cells all of which are different. I would like to do this by copying and pasting my search as a whole and not individually. How can I do that?
Solved by O. J. in 19 mins
Need Excel to look over my tree data and have it be able to search the criteria and select all the trees that match
Solved by S. Q. in 18 mins