VLOOKUP Problems

[trafficbroker]

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]

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?

Hi

Can you post your VLOOKUP formula?

Andy.

"trafficbroker" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

Hi

Can you post your VLOOKUP formula?

Andy.

"trafficbroker" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[CarlosAntenna]

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

--
Carlos

"trafficbroker" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[trafficbroker]

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]

Just tried the $ signs and it now works perfectly!

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