Give cell a value depending on value of other cell and list

[Antained]

Hello,

I have a list of shifts I did with the date. This list expands as I do more shifts.

	A	B
1	Shift	Date
2	1	date 1
3	2	date 2
4	3	date 3
5	4	date 4
6	5	date 5

<tbody>
</tbody>

I have another list of deliveries (on another sheet) with the shift given, I want to automatically get the date based on what shift it is.

	D	E	F
1	Delivery	Shift of delivery	Date
2	1	1	date 1 (automatic)
3	2	1	date 1 (automatic)
4	3	2	date 2 (automatic)
5	4	3	date 3 (automatic)
6	5	3	date 3 (automatic)
7	6	3	date 3 (automatic)

<tbody>
</tbody>

I understand that I could do a long IF but as I keep getting more shifts and more dates, I would have to manually update that if all the time.
What should the formula be for the Date in the Delivery list be?

 

[Antained]

I found it! I needed the VLOOKUP function.
Learned it with a simple youtube tutorial.
Formula in my case was: =VLOOKUP(D1,Sheet1!A:B,2,FALSE)