Help with VLOOKUP formula? or Macro that will do...
Posted on 2013-06-13
I would like a formuala copied down column T of the active sheet that would do a vlookup of the value in column B, and see if it is in column AI.
Copy the formula down column T as long as there is data in column B,
If there is a match, obviously the value will show in T, but I want that to turn green for good.
If there is no match, return the word ERROR, and turn the cell red in column T
Goal is for every row in column B that has data in it, column T will be either red or green. Thanks -R-