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

1. 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. 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. 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?

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

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