EXCEL - Problem with IF & AND Functions

[Llwynog]

Can anyone help please?

I've got a workbook with several worksheets, there are 2 that I need to link.
In one I have a list of dates(in column),and in other columns I have items:-

Date Drawsheets Pillows C/Panes
12/8/08 10 20 5
14/8/08 20 20 6
19/8/08 15 30 5
21/8/08 20 20 5

In the other worksheet I have the TODAY() field, and the list of items.What I would like to do in this worksheet is to say,if TODAY() matches any of the dates in the other worksheet, then list the items in this sheet - there are other fields in this sheet but they're not causing any problems.
Thanks,

 

[AnotherHiggins]

Have a look at VLookup

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[lionelhill]

... and pivot tables