locked
Excel Formula Question RRS feed

  • Question

  • Is it possible to include the color of a cell as a variable in a vertical lookup formula...

    i.e. If i have an orange filled '1' in cell A1 and a black filled '1' in cell A 20, how can I get the vertical lookup to recognize that there is a difference in the data? My current formula is seeing both cells as simply being a '1' and is returning the A1 data for both vertical lookups.

    Wednesday, August 11, 2010 6:43 PM