excel index match format

  1. S

    Get the references from the cells that are not blank

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...
  2. K

    Excel Index Match Return Muliple Values

    I have two sheet in a file on one sheet a have data regarding student like AdmissioNo, RollNo, Name, FatherName, Class and status. I want to generate the student list according to choice, for example if I select class 1 it should return student name list of that particular class if their status...
  3. L

    3 Way Lookup By splitting the Cell value

    <tbody> Item1 Item2 Item3 N1 N2 B C D XX MM C A A YY NN A E D WW OO A B C ZZ PP </tbody> <tbody> Item_Name F_Name L_Name A-B-C ZZ PP C-A-A YY NN B-C-C XX MM A-E-D WW OO </tbody> I have a data which is the Table-1 in one sheet and in...
  4. S

    Index Match Function Help

    Hi, I need to have an INDEX MATCH function return a value AND FORMATTING (color coded numerical values). I have been looking everywhere and cannot find any help on how to retrieve/match formatting from one set of data to another. Any ideas? THANK YOU!!!:eeek::confused:

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...