+ Reply to Thread
Results 1 to 3 of 3

Vlookup formula showing as text in cell

  1. #1
    Forum Contributor
    Join Date
    03-14-2005
    MS-Off Ver
    Office 365
    Posts
    164

    Vlookup formula showing as text in cell

    I have the following formula:

    =VLOOKUP(A2,Sheet1!A:B,2,FALSE)


    It is showing up as text in the cell it's in. Any ideas? I have changed the format of the cell it's in to be numeric, accounting, general, and still not change with a result.

    I copied the formula down and still the same in all the cells. I changed the formating of the cells in the column that I want the formula in to be numeric, accounting, general and then placed the formula in it. Still no results of data from Sheet1, only giving me the formula in the cell.

  2. #2
    Forum Contributor
    Join Date
    03-14-2005
    MS-Off Ver
    Office 365
    Posts
    164

    Re: Vlookup formula showing as text in cell

    Never mind, show formula button was clicked.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Vlookup formula showing as text in cell

    If it's showing up as text then its text

    Locate the cell in the VLOOKUP
    what does

    =ISNUMBER(cell)

    result in?

    To turn it into a number try

    =VLOOKUP(A2,Sheet1!A:B,2,FALSE)+0
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLOOKUP result is not showing up - only the formula
    By Linda in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-20-2016, 02:32 PM
  2. Replies: 2
    Last Post: 01-16-2013, 05:11 PM
  3. How to get vlookup to stop showing as formula?
    By jgomez in forum Excel General
    Replies: 3
    Last Post: 03-23-2012, 11:07 AM
  4. Vlookup Formula is showing error
    By kh0515 in forum Excel General
    Replies: 11
    Last Post: 01-12-2009, 05:37 PM
  5. VLOOKUP Formula Only Showing
    By rglasunow in forum Excel General
    Replies: 5
    Last Post: 10-17-2006, 02:52 AM

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