+ Reply to Thread
Results 1 to 3 of 3

Is there a VLOOKUP substitute when data is not in ascending order

  1. #1
    VJ7777
    Guest

    Is there a VLOOKUP substitute when data is not in ascending order

    I need to create a report (from multiple workbooks) of activities that are to
    occur "today" from a list of dates (Column A)and events (Column B). but the
    dates might not be in ascending order and some cells in Column A may not
    contain a date. There is one such "table" in each workbook. The report
    would look like this:
    Today's Date
    Workbook1 Empty trash
    Workbook2 (blank) because there is nothing to be done today
    Workbook3 Cook dinner
    Is this possible?

  2. #2
    Jason Morin
    Guest

    Re: Is there a VLOOKUP substitute when data is not in ascending order

    When you set VLOOKUP to find an exact match, your data
    doesn't need to be sorted. Set the 4th argument to 0.

    =VLOOKUP(---,---,---,0)

    HTH
    Jason
    Atlanta, GA

    >-----Original Message-----
    >I need to create a report (from multiple workbooks) of

    activities that are to
    >occur "today" from a list of dates (Column A)and events

    (Column B). but the
    >dates might not be in ascending order and some cells in

    Column A may not
    >contain a date. There is one such "table" in each

    workbook. The report
    >would look like this:
    >Today's Date
    >Workbook1 Empty trash
    >Workbook2 (blank) because there is nothing to be

    done today
    >Workbook3 Cook dinner
    >Is this possible?
    >.
    >


  3. #3
    Arvi Laanemets
    Guest

    Re: Is there a VLOOKUP substitute when data is not in ascending order

    Hi

    To avoid an error when there is nothin found:
    =IF(ISERRROR(VLOOKUP(...,...,...,0)),"",VLOOKUP(...,...,...,0))
    or
    =IF(ISNA(VLOOKUP(...,...,...,0)),"",VLOOKUP(...,...,...,0))

    --
    When sending mail, use address arvil<at>tarkon.ee
    Arvi Laanemets


    "VJ7777" <[email protected]> wrote in message
    news:[email protected]...
    > I need to create a report (from multiple workbooks) of activities that are

    to
    > occur "today" from a list of dates (Column A)and events (Column B). but

    the
    > dates might not be in ascending order and some cells in Column A may not
    > contain a date. There is one such "table" in each workbook. The report
    > would look like this:
    > Today's Date
    > Workbook1 Empty trash
    > Workbook2 (blank) because there is nothing to be done today
    > Workbook3 Cook dinner
    > Is this possible?




+ 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