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