Vlookup not working as expected - REF error

[Dellboy]

See attachment.

Hello all. Been a while since I've used excel and I'm a little rusty.

Basically, I have two sets of data, one set I need to find the match using vlookup. See example - I want to return the colour in column C, however, I get REF error using the following formula;

=VLOOKUP(B2,$E$2:$E$5,5,FALSE)

I assume column number 5 would return the value from that line. Any help would be greatly appreciated.

 

[Fluff]

How about

=VLOOKUP(B2,$E$2:$F$5,2,FALSE)

 

[Dellboy]

Still get the same error

Just looking to return the correct colour in column C

 

[RoryA]

You didn't adjust the lookup range to include column F...

 

[Dellboy]

Doh!

Silly me. Working. Thanks Both!!

 

[Fluff]

Glad we could help & thanks for the feedback.