On Jul 26, 7:49*am, Dale G wrote:
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.

You're welcome.

For the future, it is best to cut-and-paste examples to avoid such
mistakes. (Unless you are saying you had the same mistake in the
worksheet.)

If I understand you correctly, dovetailing my "PS" follow-up, you
might try the following instead:

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