Combine ADRESS and VLOOKUP

[ChicagoGuy]

I have a set of people that are forecasting their expected work completion similar to what i have listed below. You will notice in coumns H and I have a start date and end date. I actually have a few hundred rows in real life and based on various business events their start and end date may change.

Is there a way to find the first and last value in a row and then use that to pull the date from A1:F1? Seems like some sort of combinationof address and maybe vlookup but Im a bit lost.

For example I would like to have H2 say 6/2/2017 and I2 say 6/6/2017. But i cant figure out how to connect the dots.

Hopefully I am making sense. Please just ask for clarfication if you need it.

	A	B	C	D	E	F	G	H	I
1	Dates	6/1/2017	6/2/2017	6/3/2017	6/4/2017	6/5/2017	6/6/2017	START DATE	END DATE
2	MATHEW	2	2	8	4	9
3	MARK			4	1	8	7
4	LUKE		5	3	7
5	JOHN	4		6	8	9
6	RNGO	5	6	1	9	2	3

<tbody>
</tbody><colgroup><col><col span="7"><col><col></colgroup>

 

[cerfani]

thank you cerfani.

I am getting an #value error though. I see where you are going. let me see if i can figure out whats throwing the error

Dates	6/1/2017	6/2/2017	6/3/2017	6/4/2017	6/5/2017	6/6/2017	START DATE	END DATE
MATHEW	2	2	8	4	9		#VALUE!	#VALUE!

<tbody>
</tbody>

sorry for the late reply, i tested it earlier and it seemed to work ok but I guess you got it working regardless