IF A CONDITION IS MET ADD MONTH NAME

Sylvia Elizabeth

Hi,

I want to include the month name of the column of date Inicio in the column Mes inicio de obra esperado if the column Proyecto/Objetivo contains "Inicio de obra". Does somebody knows how to create a formula for this?

Thank you

David Joyeuse

Hi @Sylvia Elizabeth

Use this:

=IF([Proyecto/Objectivo]@row="Inicio de obra", vlookup(month([Inicio]@row),{NEW SHEET REFERENCE},2, false), "")

Jenna Bailey

the easiest way to do this would be to create a VLOOKUP table on another sheet that has all of the month numbers listed and in column 2 have the month name beside the month number then input the following formula

=vlookup(month([Inicio]@row),{NEW SHEET REFERENCE},2, false)

Sylvia Elizabeth

But my question also is that if Proyecto/Objetivo = "Inicio de obra", then include the month name, and if not, just not incluide the month name.

David Joyeuse

Hi @Sylvia Elizabeth

Use this:

=IF([Proyecto/Objectivo]@row="Inicio de obra", vlookup(month([Inicio]@row),{NEW SHEET REFERENCE},2, false), "")