Results 1 to 6 of 6

Vlookup = #N/A

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-21-2010
    Location
    Alta, Norway
    MS-Off Ver
    Excel 2003
    Posts
    119

    Vlookup = #N/A

    Hi,

    I am using the following IF formula;

    =IF(AND(I21>1,I21<2),VLOOKUP(A3+30,A21:G968,2,FALSE),"")

    For most of the cells this work smoothly. However;
    The lookupvalues in column A is dates. I do not have data for all the dates of the year, and therefore I get an error when the lookupdate + 30 days does not exist in my spreadsheet.

    What I am trying to do, is get the "A3+30" in my formula to become some sort of count. That is to say, I would like the values in A33 to show, regardless if this is the date in A3 + 30 days.

    Hope this explaination was good enough for someone to grasp my problem and are willing to guide me

    (If not I can provide a sample sheet)

    Gnoke
    Last edited by gnoke; 08-24-2010 at 09:41 AM.

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