+ Reply to Thread
Results 1 to 8 of 8

VLOOKUP function on Excel 2010 not working

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Houston,TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    VLOOKUP function on Excel 2010 not working

    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 !
    Attached Files Attached Files

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,117

    Re: VLOOKUP function on Excel 2010 not working

    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

  3. #3
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: VLOOKUP function on Excel 2010 not working

    Hi Kiron,

    Welcome to the forum. Try the below:

    Formula: copy to clipboard
    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.

  4. #4
    Registered User
    Join Date
    11-14-2012
    Location
    Houston,TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: VLOOKUP function on Excel 2010 not working

    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

  5. #5
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Re: VLOOKUP function on Excel 2010 not working

    Try going to File\options\formulas to check if under working with formulas you have the R1C1 box ticked.
    Jacob Albers
    Excel 2003 & 2010

  6. #6
    Registered User
    Join Date
    11-14-2012
    Location
    Houston,TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: VLOOKUP function on Excel 2010 not working

    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 ?

  7. #7
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Re: VLOOKUP function on Excel 2010 not working

    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.

  8. #8
    Registered User
    Join Date
    11-14-2012
    Location
    Houston,TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: VLOOKUP function on Excel 2010 not working

    wow! excellent. will never ever forget. I have been sweating on this for quite sometime now. Thank You again.

    KK

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1