Table Extract based on Font

Hi,

Personally I avoid trying to make Excel make decisions based on cell/font colours, backgrounds, Bold, etc. There's just too much area of risk. Someone somewhere will reformat something and screw things up. Always look for a more robust solution.

In this case one way in C" copied down would be

Formula:

=INDEX(Records!$A$1:$M$20,MATCH(A2,Records!$A:$A,FALSE),MATCH(B2,Records!$2:$2,FALSE))

Even better would be a restructuring of your data in a 3 column Table for Region, Month, Value.
You could then use a Pivot Table which opens up all sorts of possibilities for you and is far more efficient for this sort of analysis.