Get instant live Excel expert help with Text Functions

I need to format values (black text) based on if they match a value in a range of cells on a separate sheet. Match = black text, no match = red text

Hi, I'm looking to create a from by typing in the reg and it pulling through the data from the data tab. I've tried this as a VLookup but it only pulls through the first line and there may be more than one line under each reg for repair history. I tried doing this as a pivot table, but I don't like the layout of it and wanted to be able to type in a reg and it search for the data rather than filtering. I've tried a combination of both by creating a macro to copy the data from cell A1, refresh the data in the pivot table, filtering by pasting the results from A1 then copying the relevant data I require onto the form tab. It works, but when I change the reg it remembers the actual reg text from the macro rather than the act of copying and pasting the data in A1 from the form. Can you help me please?

I’m trying to use conditional formatting to create rules for cells to color code blue or red when values are either lesser or greater. Columns C7-17 and F7-17 are comparing to each other. Columns C24-50 and F24-50 are cells that allow my conditional formatting to work. Ultimately, cells F7-17 are color coded based on comparing to cells C7-17, with the work to allow this formatting following below. Looking at the attached, I need help formatting the cells F8, F10, and F12. Rules I’m struggling on in these three cells: F8: If value is comparing a $ figure to text None, the None cell should be blue. F10: If value is comparing None to $ value, the $ value should be red. If value is comparing % to $ value, $ value should be red.

Hello! I need help creating a formula. Column 1 has text values (eg. "apple", "banana", "grape"). Column 2 has numerical values. I need a formula that will calculate the sum in column 2 in relation to column 1. EG Apple | 3 Banana | 2 Apple | 5 I need something that gives me = 8 for apples

Hello! I need help with a formula. In column 1 i have various text values and in column 2 i have numerical values. I need a sum formula that selects the values for the corresponding text values, like this: Column 1 | Column 2 Apples | 2 Bananas | 5 Apples | 1 Bananans | 10 Apples Sum = 3 Bananas Sum = 15

i want to lookup a alphanumeric value(eg. EMP789 ) from a coloumn range i use =VLOOKUP(REPT("z",255),C:C,1) to get text value

want to show numbers of alphabets against given text in a cell

In excel I need to be able to find one of two words in a text string, they are not placed in the same area in the text string and the differ in words.

I need a formula that can do horizontal look up a long a row of repetitive "text" values and return the date corresponding to the cell where there is a color change For eg: Row 1: Date 1, Date 2, Date 3, Date 4, Date 5 Row 2 : Red, Black, Red, Green, Green, White Output should be date for because color changed from Green to Red

MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: I need a formula that can do horizontal look up a long a row of repetitive "text" values and return the date corresponding to the cell where there is a color change For eg: Row 1: Date 1, Date 2, Date 3, Date 4, Date 5 Row 2 : Red, Black, Red, Green, Green, White Output should be date for because color changed from Green to Red