INDEX SMALL Date Range 3 things

[R0CKY]

hi
I need a formula that will give me "work" and "vacation" and less "60" days in formula
I try two things but not working with me
DATA!D$2:D$500="WORKING")*(DATA!D$2:D$500="Vacation")* or DATA!D$2:D$500={"WORKING","Vacation"})
Need put in my formula

=T(IFERROR(INDEX(DATA!$B$2:$B$2206,SMALL(IF((DATA!$J$2:$J$2206-TODAY())<60,ROW(DATA!B$2:B$2206)-1,""),ROW(DATA!A1))),""))

Any suggestions on how I can formulate ,Thank you.

[leelnich]

I think this ARRAY FORMULA* works, hard to tell without a sample workbook to test with :
*Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.

Please Login or Register  to view this content.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now just Browse for your file, then click Upload. Simple!

[R0CKY]

Thank you leelnich this works perfect. worked perfectly. Thanks so much!

[leelnich]

You're welcome! I guess you realized it's a ARRAY FORMULA - I forgot to note that.
If complete, please mark your thread as SOLVED (Thread Tools up top). Thanks -Lee