VLOOKUP Problems

T

trafficbroker

Hi all

I have been using VLOOKUP for a while now with varying success. I hav
noticed that my Vlookups are only successful if I am findin values fro
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
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,

Mat
 
T

trafficbroker

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

Is there anyway to get around this do you think
 
T

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
 
T

trafficbroker

Just tried the $ signs and it now works perfectly!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Need VLOOKUP to Work Two Ways 0
Bugs in vlookup? 0
VLOOKUP and "-" characters 4
VLOOKUP & Array 8
Vlookup-Doesn't return values under 1 1
Vlookup in multiple columns 2
Sum Values from different column 1

Top