I need a 2 condition vlookup to lookup a date and when it matches the date
then it looks to match a state and then return a value on another worksheet.
Any ideas on how to do this?

example;
2/17/06 <---lookup this date
AZ value 1 <---Then lookup the state and then return value which is
on another worksheet
ID value 1
CA value 1
OR value 1