+ Reply to Thread
Results 1 to 3 of 3

Vlookup returns ###

  1. #1
    Forum Contributor
    Join Date
    01-26-2008
    Posts
    124

    Vlookup returns ###

    I am using the formula =VLOOKUP(F4,Scoring!$B$3:$C$66,2,FALSE) in column 'G' to return values from another sheet, 'Scoring', if column 'F' has a name in it the value is returned. The problem is if column 'F' is blank the formula returns ### and I cannot SUM column 'G'. Help please. Yhank You!

    Jim O
    Last edited by JOGIER; 03-18-2009 at 04:04 PM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Vlookup returns ###

    Hello Jim, try changing the formula as follows:

    =IF(F4="","",VLOOKUP(F4,Scoring!$B$3:$C$66,2,FALSE))

  3. #3
    Forum Contributor
    Join Date
    01-26-2008
    Posts
    124

    Re: Vlookup returns ###

    Thats it! Thanks much.

    Jim O

+ 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