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

Maybe something like this:

On Sheet2
C2: =CHOOSE(B2,Sheet1!B2,Sheet1!C2,Sheet1!D2)

Where B2 contains the traffic light code(1,2 or3)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Mazzeree" wrote:

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

Wow! It works but I can't see how it does?

Thanks

PS you can't answer my other one can you;-) Vlookup or not

"Ron Coderre" wrote:

Maybe something like this:

On Sheet2
C2: =CHOOSE(B2,Sheet1!B2,Sheet1!C2,Sheet1!D2)

Where B2 contains the traffic light code(1,2 or3)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Mazzeree" wrote:

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