Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to do this?
Im looking for a function (hopefully) that allows me to do something like this:
IF C2=Sheet!B2 then "write"Sheet!D2 ElseIF "Blank" * Also when I specity C2 (for example) I actually need it for the whole C (column), so I would need to copy it, right? *or instead of blank, fill the cell with yellow or red. Is this possible? Ivan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to do this?
Try this and drag down as required:-
=IF(C2=Sheet2!B2,Sheet2!D2,"") Mike "ivera" wrote: Im looking for a function (hopefully) that allows me to do something like this: IF C2=Sheet!B2 then "write"Sheet!D2 ElseIF "Blank" * Also when I specity C2 (for example) I actually need it for the whole C (column), so I would need to copy it, right? *or instead of blank, fill the cell with yellow or red. Is this possible? Ivan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|