| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display contents of associated cells
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- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display contents of associated cells
If ( rule B2 = True,C2,"something else")
Don wrote: 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- -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display contents of associated cells
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- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display contents of associated cells
=IF(B2=TRUE,C2,"whatever you want if B2 is FALSE") or merely
=IF(B2,C2,"whatever you want if B2 is FALSE") -- David Biddulph "Don" wrote in message ... 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- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of a specific cell even if a group of cells is mo | Excel Worksheet Functions | |||
| Big Cell Contents - I don't want them to display | Excel Discussion (Misc queries) | |||
| compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
| function to display contents of a cell | Excel Worksheet Functions | |||
| display contents of cell | Excel Discussion (Misc queries) | |||
Linear Mode
