I'm trying to use LOOKUP to place an employee's name in cell H4. The
employee's name in H4 is associated with a number (piece of work) in A4. The
number in A4 stays the same but 2 different employees do the same work on
separate days.
Monday & Friday are the days these different employee's do the work. I use
cell A1 to enter the day. My workbook has 2 sheets, sheet 1 is feeder, it has
the numbers & name. 2 is the sheet I use to record the work being preformed,
and the sheet I need the names to appear. I have come close, but I get False
next to the correct Name. Here is what I'm using.
=IF(A4="Monday",LOOKUP(A4,Feeder!$H$24:$I$43))&IF( A1="Friday",LOOKUP(A4,Feeder!$A$2:$C$83)).
This works except for when I enter Monday I get Jim SmithFALSE, and Friday
FALSEJohn Doe. How can I stop the FALSE from appearing