Hi

Can you post your VLOOKUP formula?

Andy.

"trafficbroker"
wrote in message
news:trafficbroker.252pga_1143034541.1697@excelfor um-nospam.com...

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


--
trafficbroker
------------------------------------------------------------------------
trafficbroker's Profile:
http://www.excelforum.com/member.php...o&userid=28710
View this thread: http://www.excelforum.com/showthread...hreadid=525232