Hi Kevin,
That worked brilliantly! Thank you so much. One other question: Is it possible to use the worksheet (or tab) name as the lookup value. In other words, in stead of directing the formula to $C$7, is there a way to use the worksheet (or tab) name?
Really appreciate your help on this, it has been driving me crazy.