+ Reply to Thread
Results 1 to 6 of 6

Problem with format for VLookUp

  1. #1
    Registered User
    Join Date
    08-29-2008
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    63

    Problem with format for VLookUp

    For some rerason i have copied a column across and the Vlookup does not want to work on the cells. If i double click on the cell and press enter, the vlookup then works!!!??
    Not sure why....but i have formatted all cells multiple times thinking this may be the issue.....any help appreciated.

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Problem with format for VLookUp

    it could be that yoru cells are formated as "Text" try changing the format (including the first cell) to general, then copy again.
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Registered User
    Join Date
    08-29-2008
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    63

    Re: Problem with format for VLookUp

    I have tried to format to General, but it does not work. As i said i have to double click into the cell and press enter for it to be recognised. Driving me mad!

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Problem with format for VLookUp

    did you format to general before putting the formula in there? also you will need to change the format of the cell you are copying from.

    If that does not work could you attach the workbook.

  5. #5
    Registered User
    Join Date
    08-29-2008
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    63

    Re: Problem with format for VLookUp

    I have attached a workbook that shows the issue i am having. If i go the highlighted cell and double-click into the cell and then enter, the formula will work.
    Not sure why this is so??
    Thanks...any help appreciated
    Attached Files Attached Files

  6. #6
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Problem with format for VLookUp

    it is hapening because the cells are formated as text, you just need to highlight the whole row, and select the formating option "General"

+ 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