VLOOKUP returns wrong values

**surfol** · 05-26-2011, 06:31 AM

Hello guys,

I need help on vlookup functions that I use together with dropdown list data validation.
It seems to return the wrong values, I'm not sure what I did wrong.
So, if anyone can take a look at it and help me out, it'd be much appreciated

**zbor** · 05-26-2011, 06:45 AM

You must use FALSE at the end for exact match:

=VLOOKUP(B3, $J$4:$K$10, 2, FALSE)

**pavanonly4u** · 05-26-2011, 12:04 PM

I need help on vlookup functions that,some of the results showing #N/A, but there are right result it showing wrong,So, if anyone can take a look at it and help me out, it'd be much appreciated

**surfol** · 05-26-2011, 02:36 PM

Originally Posted by pavanonly4u

I need help on vlookup functions that,some of the results showing #N/A, but there are right result it showing wrong,So, if anyone can take a look at it and help me out, it'd be much appreciated

I'm not an expert, but I see that you forgot to ANCHOR the range, that's why it returns NA.
So you just need to ANCHOR the range before dragging them down.

**surfol** · 05-26-2011, 02:37 PM

Originally Posted by zbor

You must use FALSE at the end for exact match:

=VLOOKUP(B3, $J$4:$K$10, 2, FALSE)

thanks a lot

!!

**abishekmouli88** · 05-26-2011, 02:51 PM

Originally Posted by pavanonly4u

I need help on vlookup functions that,some of the results showing #N/A, but there are right result it showing wrong,So, if anyone can take a look at it and help me out, it'd be much appreciated

See if this is fine. It works fine now, as far as I can see..!

**zbor** · 05-26-2011, 03:26 PM

Please, follow the rules...

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.