Formula to pull information based on text in another column

[RosieG1991]

I've tried a selection of formulas, mostly trying VLookups and IF statements to pull the information I need but I don't seem to be getting the result I want.

I'm trying do the following:
I want to pull the highlighted date in Table 2 (keeping in mind table 2 is on another sheet in my Workbook) into the Date column in Table 1 for A. I thought about specifying the text in column 2 of Table 2 in the formula?

Table 1

ID	Date
A
B
C
D

<tbody>
</tbody>

Table 2

ID	Month	Date
A	Jan	1/01/2018
A	Feb	2/02/2018
A	Mar	3/03/2018
A	Apr	4/04/2018
A	May	5/05/2018
B	Jan	11/01/2018
B	Feb	12/02/2018
B	Mar	13/03/2018
B	Apr	14/04/2018
B	May	15/05/2018
C	Jan	21/01/2018
C	Feb	22/02/2018
C	Mar	23/03/2018
C	Apr	24/04/2018
C	May	25/05/2018

<tbody>
</tbody>

Happy to provide more information if needed.

Any help is much appreciated!!

Cheers
R

 

[Oscar Cronquist]

What conditional formatting formula is used to highlight the date in Table 2?

 

[RosieG1991]

There is no conditional formatting formula I've just coloured the text red in this thread to highlight which field I want to pull into table 1

 

[jtakw]

Hi,

You're Not telling us under what conditions to pull what information into the Date column in Table 1.

For instance, ID A has 5 entries in Table 2, why are you wanting the highlighted date of 3/03/2018?