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


​

A1	A2	A3		M	N
1/1/2018	1 week	This need to return 1/1/2018+7 days		1 week	7
				2 weeks	14

<tbody>
</tbody>

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!!!