Checking if data matchs then sum two cells

[russellday]

Hi

I have a cell A1 that contains a date 1/1/2018 in A2 I have a review period taken from a drop down list contained in N5:N17. In M5:M17 I have the number of days that the review periods correspond to.

What I need to do is in A3 is to calculate the review date by taking the selected drop down option and comparing the N column t

o the M column and adding column N to the original date in A1 to give the review date


​

[TABLE="width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]A2
[/TD]
[TD]A3
[/TD]
[TD][/TD]
[TD]M
[/TD]
[TD]N
[/TD]
[/TR]
[TR]
[TD]1/1/2018
[/TD]
[TD]1 week
[/TD]
[TD]This need to return 1/1/2018+7 days
[/TD]
[TD][/TD]
[TD]1 week
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2 weeks
[/TD]
[TD]14
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks

 

[steve the fish]

Try:

=A1+VLOOKUP(B1,$M$5:$N$17,2,0)

 

[wideboydixon]

In A3:

=A1+VLOOKUP(A2,$M$5:$N$17,2,FALSE)

Book1
	A	M	N
1	01/01/2018
2	1 week
3	08/01/2018
5		1 week	7
6		2 weeks	14
Sheet1

Cell Formulas
Range	Formula
A3	=A1+VLOOKUP(A2,$M$5:$N$17,2,FALSE)

WBD

 

[russellday]

Perfect!!!