Ajit asked in Computers & InternetSoftware · 3 weeks ago

Need Excel 2 set up a scheduling program for a multitude of agents.?

In column A, a list of names from row 1 to row x. B1 to to F1 are the days of the week, Mon - Fri. List of names can and will change as players are added or deleted. For example: Using David, Don, Joel, Jim, Lisa, A2 through A6. in B2, if I type in Joel, in cell B4, I want the name from A2 , David, to appear. .

Mon Tue Wed Thur Fri

David Joel Lisa

Don Jimmy

Joel David

Jimmy Don

Lisa David

3 Answers

  • 3 weeks ago

    There is no Excel 2, mate.

  • 3 weeks ago

    I think you can do this with an IF statement.  

    in B4 would be this formula

    =IF(B2=A4,A2,"") Leaving the cell blank if it does not match.  

    Is this what you needed? 

  • 3 weeks ago

    Is she pretty, average or ugly?

Still have questions? Get your answers by asking now.