+ Reply to Thread
Results 1 to 2 of 2

Vlookup returns #ref

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Vlookup returns #ref

    I'm having a problem with a Vlookup and it's driving me nuts - it's probably something really simple that I've become blind to and missed (I've done about 100 different ones in different workbooks in the past day so getting a bit fed up with them!)

    The worksheet is attached.

    In sheet "Data Entry", a value is entered in cell J3 and the command button pressed.
    This populates cells J17 - J18 with values. The adjacent cells to these are vlookups which refer to the corresponding J column. It is supposed to return the values in the second column of sheet "current actual values", but all I'm getting is either #Ref or #NA and I can't for the life of me work out why.

    Can anyone have a quick look and put me out of my misery?
    Last edited by wonderdunder; 03-13-2011 at 01:40 PM.

  2. #2
    Forum Contributor
    Join Date
    02-08-2006
    Location
    UK
    MS-Off Ver
    2013
    Posts
    204

    Re: Vlookup returning #ref and cracking me up.

    My bad - I set the range wrong.

+ 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