Automatically populating data in two field based on data that is entered in a third

[MG User]

Hi

I have a spreadsheet with two worksheets, on the first I have a list of applications with two dates, the date an application was made and the date it was responded to e.g.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Application no[/TD]
[TD]Date made[/TD]
[TD]Date responded to[/TD]
[/TR]
[TR]
[TD]App-001[/TD]
[TD]01/09/2017[/TD]
[TD]05/09/2017[/TD]
[/TR]
[TR]
[TD]App-002[/TD]
[TD]04/09/2017[/TD]
[TD]15/09/2017[/TD]
[/TR]
[TR]
[TD]App-003[/TD]
[TD]01/10/2017[/TD]
[TD]10/10/2017[/TD]
[/TR]
</tbody>[/TABLE]

On the second worksheet there are a number (approx 10) other columns that include the three above.

My question is, on the second worksheet I add the application number by hand but then, based on the data I entered, I want the start date and responded date to auto-populate (and to update automatically if the first worksheet is changed). Is there a way of doing this in Excel? Ideally without macros as they are a bit out of my comfort zone.

Thanks for your help

 

[Peter_SSs]

Welcome to the MrExcel board!

Sounds like you could use the VLOOKUP function.

Book1
	A	B	C
1	Application no	Date made	Date responded to
2	App-001	1/09/2017	5/09/2017
3	App-002	4/09/2017	15/09/2017
4	App-003	1/10/2017	10/10/2017
Sheet1

Book1
	A	B	C	D	E	F
1	Application no			Date made		Date responded to
2	App-002			4/09/2017		15/09/2017
3	App-001			1/09/2017		5/09/2017
Sheet2

Cell Formulas
Range	Formula
D2	=VLOOKUP(A2,Sheet1!A$2:B$10,2,0)
F2	=VLOOKUP(A2,Sheet1!A$2:C$10,3,0)

 

[MG User]

That did it, thank you very much!

 

[Peter_SSs]

That did it, thank you very much!

Good to know. Thanks for getting back to us.