Get instant live Excel expert help to learn how to use Search function in Excel?

Is there a way to a new rows with cell data, based on the data from other cells? I have VB script that download stock prices directly from google, they get displayed in a column with price and time in sheet A. These data I will use in another sheet B in a new row for every time I search up a new stock. When I add a new stock, the data will change in the cells for the script. These data should then be added to a new row in sheet B, and not replace the data in the cell that already have the other stock pries. So a dynamic script that adds new rows in sheet B when the data in the VB script changes.

Hi- I have a workbook and I need one page to search a few columns in the workbook and if the cell contains the word "none" I want it to put the word "no" in the cell and if it doesn't contain the word "none" I want it to say "yes"

Need web search from excel with cell values as search subject. Subject can be in multiple cells as well. So, I need a code with search button with cell value as subject for web search.

Hi, I am trying to create an iterative query using Power Query (to search through > 1,000 URLs) and a screener/filter that lists only certain results according to specified criteria that are laid out in additional columns next to the Power Query table. I know you can set up loop queries with Power Query but adding the screener part on top is beyond my knowledge base...

This formula isn't working consistantly and I'm not sure why: =ARRAY_CONSTRAIN(ARRAYFORMULA((SUM(IF(ISNUMBER(SEARCH("*Adler & Associates-*",$J$3:$K$200)),1,0))-SUM(IF(ISNUMBER(SEARCH("/",IF(IF(ISNUMBER(SEARCH("*Adler & Associates-*",$J$3:$K$200)),1,0)=1,$J$3:$K$200,""))),1,0)))*1+SUM(IF(ISNUMBER(SEARCH("/",IF(IF(ISNUMBER(SEARCH("*Adler & Associates-*",$J$3:$K$200)),1,0)=1,$J$3:$K$200,""))),1,0))*0.5), 1, 1)

need help with creating a formula where i want to merge different sheets all together which contain same data but columns can be different there are huge columns so i need it to be automated using some formula is this possible to search the data in another sheet and fill it

Hello! I am working with two columns in excel. I'd like to search Column A to find when the value changes. Then I'd like for the value of Column B to autofill down only when all the Column A values are the same.

How to search for an entry in an Excel spreadsheet

I have a spreadsheet with all of my pricing for each material as a different tab. Each tab is set up the same for price of material, area its being delivered to with mileage, quantity of material with discounts after a certain unit. I am looking to make a separate tab that utilizes a drop down selection labeled "Order form". I want to be able to click each drop down and pick the material, location its being delivered to and the unit sold and have it pull the data from my other tabs to have it generate a price. I highlighted the spreadsheet to help explain what I'm looking to do. Look at the order form tab and see an example of what i want it to generate. If i click the drop down and and pick junk 1 i want it to narrow the search to that tab. Then when i click Bristol and 8 units in the drop downs i want it to find the intersection which will be the cost. you will see the example highlighted in yellow and red.

I have a formula that is based on cell E3. I would like that if there is no data or text in column U, that no data is entered into HM3-18. There is another cell that is based on data in column U. I currently have this formula in colum U: =IF(ISNUMBER(SEARCH("",$E$3)),$E$3,"")