sorry, that was a typo. thanks for pointing that out.

"Don Guillett" wrote:

Untested but you might try.

=LOOKUP(A4,if(a1="Monday",Feeder!$H$24:$I$43,FeeÂ* der!$A$2:$C$83)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dale G" wrote in message
...
Thank you, that's what I needed to Know, it works great. Also I notice I
made a mistake when writting my post, A1 is for Monday & or Friday.

"joeu2004" wrote:

On Jul 25, 7:35 pm, Dale G wrote:
Here is what I'm using.
=IF(A4="Monday",LOOKUP(A4,Feeder!$H$24:$I$43))&
IF(A1="Friday",LOOKUP(A4,FeeÂ*der!$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

That's why IF() has 3 parameters. You need to put something in the
3rd parameter, probably "" (null string). Try this:

=IF(A4="Monday", LOOKUP(A4,Feeder!$H$24:$I$43), "") &
IF(A1="Friday", LOOKUP(A4,FeeÂ*der!$A$2:$C$83), "")


----- original posting -----

On Jul 25, 7:35 pm, Dale G wrote:
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,FeeÂ*der!$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