VLOOKUP with Dates not working

[Lefty099]

Hi all, hopefully this will be a simple one for you.

I am looking for a formula that I can put in a table to do the following.

Sheet1 Column C has a list of my products. Column E contains the date the goods were received.
(For some reason, and it is unavoidable unfortunately, the report the data comes from on sheet 1 posts 2 rows for the same product with a true date and a 0 on the next row. I have put an example down below.


Sheet 2 Column B has a formula transferring the product name across from sheet1.

Sheet2 Column C should have the corresponding date from sheet1.

=VLOOKUP(B4,Sheet1!B1:e20000,Not Valid,FALSE) isnt working.

any suggestions would be greatly appreciated.

Sheet1
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Hammer[/TD]
[TD][/TD]
[TD]23/06/2015[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Hammer[/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Wrench[/TD]
[TD][/TD]
[TD]17/01/2012[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Wrench[/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]Hammer[/TD]
[TD]23/06/15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]Wrench[/TD]
[TD]17/01/12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have no VBA experience hence why I am chasing formulas to do this.

Thanks in advance.

 

[B___P]

My pleasure,
it is strange there is no built in function in Excel to do this job.

Have a great Sunday