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

	C	D	E	F
1	Hammer		23/06/2015
2	Hammer		0
3	Wrench		17/01/2012
4	Wrench		0

<tbody>
</tbody>

Sheet2

	A	B	C	D
1		Hammer	23/06/15
2		Wrench	17/01/12
3
4

<tbody>
</tbody>

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