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 need a formular that would check if a cell is empty, if it's empty, then do a lookup to search a name from another sheet in a column in the current sheet and return YES is a match is found, otherwise, return NO
Solved by D. J. in 14 mins
I need to match some SKU codes to UPC codes.
For example, in I2 I have an SKU "FG-20C-ADSL-A" and in J2 I need the correlative UPC code found in a seperate sheet.
In the seperate sheet I have two columns: SKU codes and UPC codes. Is there a way to get the UPC column in sheet 1 to search for the SKU in sheet 2 and then return the UPC code back into sheet 1?
Cheers
Solved by G. E. in 19 mins
i need a formula to search for qty on hand for a specific product only from a certain store
Solved by Z. H. in 30 mins
I currently have a project hazard log, in which hazards are put into different sheets depending on the type of hazard. In each of these sheets there is a column stating the location of each hazard. I want to be able to, on a new sheet, search for a specific location and return all hazards (of all types) at that location, and all of the data relating to each hazard. How do I do this?
Solved by A. L. in 15 mins
I have 200 companies in UK and im trying to get phone numbers each company? is it possible to do format or something? Not like copy company name in google to search Phone number, then copy phone no and paste into excel. thanks.
Solved by G. A. in 27 mins
Hey can i get your help about search phone number from google with companies name
Solved by X. D. in 24 mins
search phone number from google with companies name on excel
Solved by K. B. in 23 mins
I need to search a list of values so i dont have to do it one by one
Solved by X. A. in 14 mins
This is what i need to do. I need to import search data from a website. I have a list of addresses that I need to search for their actual owners name and address. When property address gets entered into the search on the website the information comes right up I need to have the owners name and address imported to my excel spread sheet.
Solved by G. Q. in 12 mins
Range("B9").Formula = "=SUM(=LEFT(T25, SEARCH("x",T25,1)-1))" Having trouble insert this formula into a cell via a macro
Solved by I. H. in 11 mins