If+edate

[Gwill1983]

Hi all,

I have a large spreadsheet pulling results from multiple tabs into one pivot table to track the status of various things. Within this, there are several different rules for several different manufacturers.

I have a current formula in cell N2 which is =IFERROR(EDATE(L2,VLOOKUP(F2,Manufacturers!$A$2:$B$20,2,0)),"")

This pulls the correct data to show the closing date of the quote.

What I am trying to do is also make this cell have an IF argument which shows that if cell P2="No" then this cell (N2) remains blank. I have tried to simply add the if function after the IFERROR part of the formula but this doesn't work.

Does anybody have any ideas how I can add this element?

Thanks

Chris

 

[Fluff]

How about
=IF(P2="No","",IFERROR(EDATE(L2,VLOOKUP(F2,Manufacturers!$A$2:$B$20,2,0)),""))

 

[Gwill1983]

Yes! That worked perfectly! Thanks for your help

 

[Fluff]

You're welcome & thanks for the feedback