LinkBack URL
About LinkBacks
surfol 
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
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
Last edited by NBVC; 05-26-2011 at 03:39 PM. Reason: solved
You must use FALSE at the end for exact match:
=VLOOKUP(B3, $J$4:$K$10, 2, FALSE)
Never use Merged Cells in Excel
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.Originally Posted by pavanonly4u
So you just need to ANCHOR the range before dragging them down.
Re: VLOOKUP returns Some Values as #N/A
See if this is fine. It works fine now, as far as I can see..!
thanks a lot
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks