Edate & if?

[Gwill1983]

Hi all,

I am newly registered on the forum, but have been using it to solve my problems for a long time now. I haven't been able to find a solution to my problem on this occasion however.

I have a spreadsheet whereby I need to add a certain number of months onto the quotation validity period. I have been doing this using EDATE successfully so far. I now need to adjust this formula to add a certain number of months depending which manufacturer the quotation is from as they all have different validity periods..... I am now struggling!

My spreadsheet currently has the quotation date in column H named Opening Date and my formula in column I is =EDATE([@[Opening Date]],6). I now want to amend this formula to take into account which manufacturer is selected in column D.

If there is anybody who can help then that would be great as I have run out of ideas.

Thanks

 

[Joe4]

Add 0 or False to the Vlookup for exact match

Good catch! Can't believe I missed that...