Display contents of associated cells

[Don]

Hi,

If I have a rule in (say) cell B2 to deliver a a specific piece of
information, how would I consider composing an alternate rule that displays
the content of another cell aligned with it eg if(ruleB2=TRUE) then display
contents of C2 ...

Does that make sense ;(

Don-

 

[Max]

Maybe you meant to do this?
In say, E2: =INDEX(C:C,MATCH(B2,D,0))
E2 returns the corresponding value in col C where B2 is first found in col D
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik

 

[David Biddulph]

=IF(B2=TRUE,C2,"whatever you want if B2 is FALSE") or merely
=IF(B2,C2,"whatever you want if B2 is FALSE")