VLOOKUP not returning any results? Please help?

[kwillo]

Good morning everyone,

I'm struggling with a vlookup today and I can't understand why it isn't working!

I have two tabs the first tab looks like this:

A	B	C	D
	01/01/2017	02/01/2017	03/01/2017
From	=IFERROR(VLOOKUP(B2,'journey details'!$D$2:$D$4,3),"")
To

<tbody>
</tbody>

The second tab, "journey details" looks like this:

A	B	C	D	E	F
Ref	Surname	First Name	Date	Reg	From
1	Bloggs	Joe	01/01/2017	AB200 VYR	Home
2	Bloggs	Joe	02/01/2017	AB200 VYR	London
3	Bloggs	Joe	03/01/2017	AB200 VYR	London
4	Bloggs	Joe	04/01/2017	AB200 VYR	Home

<tbody>
</tbody>

I'm trying to match the dates on the first tab with the second but return the results from column F of the second tab. Any ideas why I'm not getting anything? I'm currently using the formula =IFERROR(VLOOKUP(B2,'journey details'!$D$2:$D$4,3),"") in the first tab.

Any help would be very much appreciated!! Thanks everyone!

 

[Canapone]

Hi,

a first answer: maybe you have to extend the reference range

=IFERROR(VLOOKUP(B2,'journey details'!$D$2:$F$10,3),"")

Regards

 

[admiral100]

Hi,
Try this

=INDEX('journey details'!$F$2:$F$5,MATCH(B2,'journey details'!$D$2:$D$5,0))

 

[kwillo]

Thank you so much worked perfectly!