Hi (me again)

I'm sorting all my problems out today.

I have 120 groups, they have all been traffic lighted against 20 indicators.

I now have 1 workbook with 121 sheets in - on each sheet is a single
practice, with thier 20 indicators in column A and thier performance in
colmun B cloured Red, Amber or Green. (also behind these colours are the
numbers 1, 2 or 3

On sheet 1 I have all 20 indictors listed (column A) and Comments for Red
(column B) Amber (column C) and Green (column D)

How can I make each sheet look at the first sheet and if there's a 1 (Red)
in column B enter the corresponding red comment from sheet 1 in Column C and
so on for 2(Amber) or 3 (Green)

I've only ever used IF in the 'if its greater than enter 1 otherwise 0
senario so not sure if its possible for this sort of thing.

All help appreciated

determined UK AKA Mazzeree

Please help