The Vlookup function on Excel 2010 is not retrieving the right data. I tried everything possible , but it does not return the correct answer. attached herewith is a sample data with just 3 row and cloumn and wrote a vlookup for that table. It doent work!. please help !
Change your formula to
=VLOOKUP(E5,$B$6:$C$10,2,FALSE)
and copy down. You were referencing the sl nr. and not the name.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Kiron,
Welcome to the forum. Try the below:
Formula:
Please Login or Register to view this content.
Your lookup range started from column A instead of B hence your formula was showing error. Also, use "False" as the condition in vlookup's to get the exact result instead of using "True" and getting close results.
Hope this helps.
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
Thank You, But when I do a F2(to see the formula) on the formula the highlighted cells are the same as name and the table. however, I see something wierd on my excel. after applying the formula, my column and row both changed to numbers. I do not have ABC there..Attached is the screenshot.
Vlookup Error Screenshot.jpg
Try going to File\options\formulas to check if under working with formulas you have the R1C1 box ticked.
Jacob Albers
Excel 2003 & 2010
That did work. But can you tell me what was I doing wrong. I selected the entire table instead on only 2 column.
Should we start the column with the one we are referencing ?
with a vlookup you give it what you are looking for and that must be the leftmost column. You were referencing the Sl.No but you told it to find John Doe, John Doe doesn't exist in column A. Change to column B and tell it only look 2 columns right and presto, it pulls up what you are looking for.
wow! excellent. will never ever forget. I have been sweating on this for quite sometime now. Thank You again.
KK
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks