Vlookup challenge

[BT1976]

To all EXCEL wizzards - Can you please help me to resolve the following riddle:

I have two worksheets. One carries a calendar and looks like the table below:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Title[/TD]
[/TR]
[TR]
[TD]1/4/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/4/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/4/17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4/4/17[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

and the second carries the following table:

[TABLE="width: 500"]
<tbody>[TR]
[TD]DATE 1[/TD]
[TD]Title 1[/TD]
[TD]Date 2[/TD]
[TD]Title 2[/TD]
[TD]Date 3[/TD]
[TD]Title 3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am looking for a formula which would automatically populate the Title cell from the 1st worksheet by matching the date from the second table and then show the corresponding title. Unfortunately, vlookup only allows me to populate DATE 1.

So grateful for your help

BT1976

 

[WaterGypsy]

Try using something like this:

=if(ISNA(VLOOKUP(for date1)=false,VLOOKUP(for date1),if(ISNA(VLOOKUP(for date 2)=false,VLOOKUP(for date 2),if(ISNA(VLOOKUP(for date 3)=false,VLOOKUP(for date 3),""))))