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

Ive just been studying the formula and the problem is that when i drag
down the formula to my other values it changes the lookup cell to
match. Hence the lookup value is incorrect if it has been copied down a
larger data set.

Is there anyway to get around this do you think?


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

Use dollar signs to lock the rows on your lookup range (A$1:A$3) before you
fill down the column.

--
Carlos

"trafficbroker"
wrote in message
news:trafficbroker.252pon_1143034803.1019@excelfor um-nospam.com...

Ive just been studying the formula and the problem is that when i drag
down the formula to my other values it changes the lookup cell to
match. Hence the lookup value is incorrect if it has been copied down a
larger data set.

Is there anyway to get around this do you think?


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

Sorry i was away from my desk. Thanks for the help

My formula is =VLOOKUP(A6,TEST!A3:F3,6,FALSE)

I drag this down accross 50 values


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

Just tried the $ signs and it now works perfectly!

Thanks for all your help, you have saved me loads of time! :)


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

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