Vlookup question

[Belleke]

When I fill date paid on in sheet 2 column B iwant to fill column I on sheet1 automatically with the dates.
See example.
Thanks in advance.

 

[herofox]

hi,you can use this

=LOOKUP(2,1/('Sheet 2'!$D$3:$D$160=$D5),'Sheet 2'!$B$3:$B$160)

or this

=VLOOKUP(D3,CHOOSE({2,1},'Sheet 2'!$B$3:$B$6,'Sheet 2'!$D$3:$D$6),2,0)

 

[Belleke]

Formula 1 works but when there is not a date filled yet it puts 0/01/1900 as date, when there is no date filled in then the cell should stay empty
Thanks in advance

 

[bosco_yip]

Or, use :

=IFERROR(1/(1/LOOKUP(9^9,'Sheet 2'!$B$3:$B$100/('Sheet 2'!$D$3:$D$100=D3))),"")

Or,

=IFERROR(1/(1/VLOOKUP(D3,IF({0,1},'Sheet 2'!$B$3:$B$100,'Sheet 2'!$D$3:$D$100),2,0)),"")

 

[Belleke]

Thanks bosco yip.
Works perfect