Hi all

I have been using VLOOKUP for a while now with varying success. I have noticed that my Vlookups are only successful if I am findin values from a larger data set and adding them to a smaller data set.

When I try to find values from a smaller data set and add them to a larger one it only finds the first value and N/A's the rest.

Eg
Small
1
2
3

Large
1 a
2 b
3 c
4 d
5 e

Vlookup is fine.

Large
1
2
3
4
5

Small
1 a
2 b
3 c

Vlookup only finds "1"

Would really appreciate some help on this!

Thanks in advance,

Matt