=IF($A$1="Friday",$A7<950,VLOOKUP(A7,Feeder!$H$3: $I$20,2,0),VLOOKUP(A5,Feeder!$A$2:$C$118,3,0))

Whether this works or not I don't know but here's how you can write that
formula:

=IF(AND($A$1="Friday",$A7<950),VLOOKUP(A7,Feeder!$ H$3:$I$20,2,0),VLOOKUP(A5,Feeder!$A$2:$C$118,3,0))

--
Biff
Microsoft Excel MVP


"Dale G" wrote in message
...
Hi,
I'm trying to return an employee's name in column I using VLOOKUP from the
value in column A.
The value is a number that the employee is assigned as a piece of work.
The numbers are 200-899 and these employees work Monday - Friday, 900-949
Work Monday - Thursday, & 950-999 work Tuesday - Friday.
On Friday 900-949 is done by an employee who will work Friday, Saturday,
Sunday, & on Monday the same employee will be assigned a 950-999 piece of
work. (Saturday & Sunday has a different set up)
So far I've been using 3 formulas to accomplish this LOOKUP and they are;
This is for all the numbers Monday-Friday
=VLOOKUP(A3,Feeder!$A$2:$C$118,3,0)
This is for 900-949 with Friday off (which will use the same lookup as
above
on Monday-Thursday)

=IF($A$1="Friday",VLOOKUP(A4,Feeder!$H$3:$I$20,2,0 ),VLOOKUP(A4,Feeder!$A$2:$C$118,3,0))
This is for 950-999 with Monday off (which will use the same lookup as
above
on Tuesday-Friday)
=IF($A$1="Monday",VLOOKUP(A5,Feeder!$H$22:$I$39,2, 0),VLOOKUP(A5,Feeder!$A$2:$C$118,3,0))
Is it possible to have one formula that would do the job of these three?
I've been trying to have something like this but I can't get it to work.
=IF($A$1="Friday",$A7<950,VLOOKUP(A7,Feeder!$H$3:$ I$20,2,0),VLOOKUP(A5,Feeder!$A$2:$C$118,3,0))
Any help is appreciated.