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
Hey, I need help with using vlookups. I have two tables with dates, numeric codes, and marketing metrics. I need it to search for both the date and numeric code and then report back the marketing metric for that date and code.
Solved by V. E. in 12 mins
I have a spreadsheet with multiple tabs and will be adding more tabs as we go. I need a formula that will allow me to search for something that may be on any one or multiple sheets and return the a one or a list of companies that match the search.
Solved by E. E. in 17 mins
I need a formula to use a text string from sheet 1 as a reference to search in sheet 2 to find a number in a different column that the same text string should be found.
Solved by B. U. in 11 mins
I have a googlesheet link.
Im trying to use VLOOKUP to search for data based on multiple criteria.
For example it looks at cell B4 then searches the tab "Elite Data" to find out all results from that area who have stores that aren't registered on the app
Solved by I. D. in 23 mins
I need to input a formula into Sheet1, that searches for a value in Sheet2 (C5:C56) that is present in Sheet1 (defined cell, C5), and then if "true", enter the value that's in the same row as the value has been found in Sheet2 but from column E.
e.g. sheet1 the set value is A. Search Sheet to C5:C56 for "A" and if found (say C35) then enter cell value of E35
Solved by Z. S. in 20 mins
I have a google sheets doc.
on the sheet TEST in cell E28 I need it to search the sheet "DisplayShare/Zone Data" and bring up all the values from that sheet that show as #N/A.
I have similiar formulas on the TEST sheet which use an ARRAYFORMULA
Solved by G. L. in 21 mins
I have a google sheets doc.
on the sheet TEST in cell E28 I need it to search the sheet "DisplayShare/Zone Data" and bring up all the values from that sheet that show as #N/A.
I have similiar formulas on the TEST sheet which use an ARRAYFORMULA. I just need the existing formula modified to work
Solved by D. Y. in 20 mins
I want to combine vlookup different sheet and sum function.
i want to search different expense head in column I and through vlookup and sum them in one formullah
Solved by M. H. in 17 mins
Hello, I would like to search for a value across multiple sheets and return a list of all cell locations with that value. Can it be done?
Solved by F. S. in 21 mins
I am trying to compare columns/ Column A has 22701 line items and another column B has 5000 line items.Both column A and B have similar quantities. I want to sort the data in a specific way in column C (blank column) where it returns the search value of column A against its original location.
Solved by M. S. in 24 mins