Display Text from Date Range

[mcdc01]

Hello,

I have text in a cell in a row on worksheet that corresponds to a specific
date in another cell within the same row. Example data below:

Column A Column B Column C Column D
2/10/07 Dev_Assigned 1-Critical CW App Issue
2/11/07 Dev_Assigned 1-Critical CW Env Issue
2/12/07 Test 1-Critical 1-Critical CW Env Issue
2/13/07 Dev_Assigned 2-High CW Env Issue
2/14/07 Test 3-Medium CW Data Issue
2/15/07 Open 2-High 2 CW User Issue

If today is 2/11/07, How do I get the text from Column D to display in a
cell in another worksheet that is specific to the same date? Also, is it
possible for the text in Column D to be auto-populated for the cell on
another worksheet provided that Today matches a date in Column A for each day
the spreadsheet is opened on?

 

[daddylonglegs]

You can use a simple VLOOKUP. Assuming your data in a sheet called "date
data" try


=VLOOKUP(TODAY(),'date data'!A1365,4,0)

adjust range as necessary

 

[mcdc01]

VLOOKUP worked perfectly!!

Thank you!!!!