lookup and give an array/list

**NBVC** · 01-29-2010, 04:50 PM

Originally Posted by ehassell01

can this be done without using arrays?

Yes... see here for an example...

http://www.excelforum.com/excel-gene...worksheet.html

Please do not continue on this thread... If you have further questions, please begin a new thread.

**livinglegend629** · 01-29-2010, 05:59 PM

I've attached a dummy workbook with just a few items but I want to have a list that shows which of the PMs are either due in 5 days or which ones are in an urgent state. Since I can use conditional formatting to define URGENT as being due in 5 or less days, that can be equivalent to sorting by due date. I don't necessarily want an input field, I just want the user to see which ones are due in 5 days. I appreciate your help and patience. I'm very new to doing these kind of things in excel.

**NBVC** · 01-30-2010, 11:20 PM

Please see attached

The formula in column D looks for items that are less than or equal to 5 days from today's date.

Also, I don't know if you were requesting help with the conditional formatting, so I took the liberty of doing it anyways for you.

The conditions I used were ... within 5 days -- Red
within 10 days - Amber
over 10 days away - Green

You can change as desired.