MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If my If Statement only had a brain


Posted by Kris on August 22, 2001 12:32 PM

I need a formula that will recognize specific dates. For example, if I enter a date the formula would bring up only the data that corresponds to that date. The data that needs to be brought up will be coming from a separate worksheet.


Posted by steve w on August 22, 2001 5:34 PM

Try using VLOOKUP or MATCH AND INDEX together.
These functions I think would be a good starting point.

steve w