Adding text from another cell into a formula.

[MKDC1303]

Hi,

I have the following formula in column Z836

=IF(OR(I836="Awarded",I836="To Be Quoted"),"Outstanding",Y836)

I want to add text from AC836 in the equation.

The text in column AC is not all the same, eg it might be Joe, or Bob, or Ralph.

The end result would be, Outstanding - Ralph or Outstanding - Joe, etc etc

Is this achievable ??

Any assistance would be much appreciated.

Thanks,
Mike

 

[Zot]

Try
=IF(OR(I836="Awarded",I836="To Be Quoted"),"Outstanding" & " - " & ACx,Y836)

where x = row number

 

[MKDC1303]

Try
=IF(OR(I836="Awarded",I836="To Be Quoted"),"Outstanding" & " - " & ACx,Y836)

where x = row number

Perfect, thankyou.!!

 

[MKDC1303]

Perfect, thankyou.!!

On last one if I can !

In the same spread sheet, I have this in VBA

ActiveSheet.Range("$A$3:$AH$6000").AutoFilter Field:=25, Criteria1:= _
        "Outstanding - 3rd Party"

I now need to add a second criteria to be sorted from the one Macro.
Eg, such as , and I know it's not right...

ActiveSheet.Range("$A$3:$AH$6000").AutoFilter Field:=25, Criteria1:= _
        "Outstanding - 3rd Party" + "Outstanding - MTMM"

Is this possible ?

 

[Zot]

On last one if I can !

In the same spread sheet, I have this in VBA

ActiveSheet.Range("$A$3:$AH$6000").AutoFilter Field:=25, Criteria1:= _
        "Outstanding - 3rd Party"

I now need to add a second criteria to be sorted from the one Macro.
Eg, such as , and I know it's not right...

ActiveSheet.Range("$A$3:$AH$6000").AutoFilter Field:=25, Criteria1:= _
        "Outstanding - 3rd Party" + "Outstanding - MTMM"

Is this possible ?

This article shows how put put 2nd criteria and also operator OR, AND , whatever

VBA AutoFilter

Excel VBA AutoFilter AutoFilter in VBA is which we can use as an expression. The syntax for it is as follows: Expression. Autofilter(Field, Criteria 1,

www.wallstreetmojo.com

 

[MKDC1303]

Awesome work, thankyou...