MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Lookup Formula

Posted by Barbara Johnson on June 14, 2001 7:21 AM

Using Excel 2000, I need to create a formula that will allow me to type a date into a cell(ie 4/1/01) and return only the names of people who are available on that day given the following data. I need for the formula to work when I change the names, dates, and available status. ?????

Name Date Available
Johnson 4/1/01 Yes
Johnson 5/1/01 No
Collins 4/1/01 No
Smith 5/1/01 Yes

Posted by Big Bob on June 14, 2001 7:50 AM

In Excel 97 you don't need a formula
You can click on any cell in your table
then select Data->Filter->Autofilter and a
drop down arrow will appear by your headings
Click on Date and a list of unique dates will appear
Select the one you want and only those rows
with that date will show .Do the same again
for availability clicking on yes and there are the people available