Hi,
Im trying to return an employees 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 Ive 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?
Ive been trying to have something like this but I cant 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.