search a cell

I'm creating a product table in excel containing about 200 products. Each of these products can be used as a component in multiple applications and they can have multiple useful descriptions. Some products might be usable in 10 or more applications or have similar descriptions. Rather than...

Hello, I have "Sheet1" Company Schedule Date Microsoft 2 hours (10h00-12h00) 13-Oct-22 IBM 4 hours (09h00-13h00) 15-Oct-22 Dell 3 hours (13h00-16h00) 13-Oct-22 Then "Sheet2", =TODAY() =A1+1 =B1+1 =C1+1 =VLOOKUP(A1,Sheet1!A1:C4,????,FALSE)...

So I am Struggling with finding a way to have a formula that will search column C for certain words that will then categorise them into column D. For example with the text cell C2 contains "Zoom" Cell D2 = Software, Cell C3 contains Zipcar cell D3 = Travel, C4 Contains " Voxi", D4 =...

Hi I´m sitting with a job-task I would like ideas on. I got two tables. See picture attached. 1. "Pricelist" with product-numbers and prices (Column B+C) 2. "Brochure" that contains same information. (F+G) I need to update prices from my "Pricelist" to my "Brochure". My idea: 1. Search...

Hello, Im new in VBA, and im searching for a script that would search in multiple sheets within one woorkbook, for specific text (specified in script itself) and paste it in a new sheet. for a descritpion: - multiple sheets (search in all of them) - skip new reference sheet + few others...

Hi Guys, (All EXCEL.LENT ladies and gentlemen) I have text in Column A. Here are the rows of the table that start with the following characters: <A1 ... For example: <A1 S = "20" D = "5.70" Z = "15.68" Date = "2021-03-25" F = "1000615" Abj = "DE09876547" /> Then the lines follow <B2 <C1 The...

Column A contains strings Column D Contains a list of words to search for Column B returns true if whole word found Only return true if whole word is found eg Dog not DogD If not in list return a null cell ---- If possible I would a more detailed result Column A contains strings Column D...

Each day I get in a bank statement, and on there I need to search within the reference column for specific text in the form of invoice numbers. but to get around the fact the invoice numbers and letters are different, I want to make a table with these values in, but have wildcards in between...

Hi I've got three formulae that work in isolation, but not together. If the text "4 for 10" is in cell A1, I'd like one formula that returns the text "Multi deal where X<Y" if 4 is greater than 10, which it is. But returns "Multi deal where X>Y"if the text in cell A2 was 10 for 4. The...

Hi I have data where the word "for" will appear in cells and if two numbers in the cell are the same, then I'd want to return the word "volume" and if the first number is bigger than the second, then I'd want to return the word "value" To give a simple example, let's assume that 3 for 3...

I need to determine if the individual cells in column A (A1:A17933) contain text from any of the cells in column C (C1:C1957), and if so, return the column C cell's corresponding value in column D (D1:D1957) to the column B cell next to the column A cell containing the column C cell text. For...

I have been using the VBA program on Excel 2010, Windows 7 below but I would like to change it from searching one number to one set of numbers (see my notes below) entered in cell C17. Can this program be used for that purpose? Wondering if someone could look at it and provide any feedback...

Hi, I need some help with creating a loop macro, hope someone would be so kind and help me i need to search all cells in a range (b2:y200) if a value (value would be a name - so text) is found, i would like to go to sheet ("data") find the value in range (B2:B100) and copy the cell to the...

Hello, I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category> <colgroup><col><col></colgroup><tbody> =INDEX(CATEGORIES,MATCH(TRUE,ISNUMBER(SEARCH(KEYWORDS,A2)),1)) I am using this formula. But keep getting an #NA...

This is the formula I'm attempting to use (which, I have used in the past and no issues): =IF(ISNUMBER(SEARCH("Sport Slotted - GM - 126.62092SL","Slotted")), "Yes", "No") This Always returns NO unless I put the whole search string as "Sport Slotted - GM - 126.62092SL", which defeats the whole...