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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]01/01/2017
[/TD]
[TD]02/01/2017
[/TD]
[TD]03/01/2017
[/TD]
[/TR]
[TR]
[TD]From
[/TD]
[TD]=IFERROR(VLOOKUP(B2,'journey details'!$D$2:$D$4,3),"")
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]To
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]Ref
[/TD]
[TD]Surname
[/TD]
[TD]First Name
[/TD]
[TD]Date
[/TD]
[TD]Reg
[/TD]
[TD]From
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Bloggs
[/TD]
[TD]Joe
[/TD]
[TD]01/01/2017
[/TD]
[TD]AB200 VYR
[/TD]
[TD]Home
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Bloggs
[/TD]
[TD]Joe
[/TD]
[TD]02/01/2017
[/TD]
[TD]AB200 VYR
[/TD]
[TD]London
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Bloggs
[/TD]
[TD]Joe
[/TD]
[TD]03/01/2017
[/TD]
[TD]AB200 VYR
[/TD]
[TD]London
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Bloggs
[/TD]
[TD]Joe
[/TD]
[TD]04/01/2017
[/TD]
[TD]AB200 VYR
[/TD]
[TD]Home
[/TD]
[/TR]
</tbody>[/TABLE]


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!