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
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]









Table 2
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Month[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Jan[/TD]
[TD]1/01/2018[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD]Feb[/TD]
[TD]2/02/2018[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD]Mar[/TD]
[TD]3/03/2018[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD]Apr[/TD]
[TD]4/04/2018[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD]May[/TD]
[TD]5/05/2018[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Jan[/TD]
[TD]11/01/2018[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD]Feb[/TD]
[TD]12/02/2018[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD]Mar[/TD]
[TD]13/03/2018[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD]Apr[/TD]
[TD]14/04/2018[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD]May[/TD]
[TD]15/05/2018[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Jan[/TD]
[TD]21/01/2018[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD]Feb[/TD]
[TD]22/02/2018[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD]Mar[/TD]
[TD]23/03/2018[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD]Apr[/TD]
[TD]24/04/2018[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD]May[/TD]
[TD]25/05/2018[/TD]
[/TR]
</tbody>[/TABLE]

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?