Maybe you meant to do this?
In say, E2: =INDEX(C:C,MATCH(B2,D: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
---
"Don" wrote:
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-