Hi guys,

I am using the formula below to lookup a person in a table when the persons'
name is entered in box F2 and return a specific value relating to that person
on a particular day when the specified day is entered in cell O2.

=IF($O$2="Monday",VLOOKUP($F$2,'[Heart Rate.xlsx]Week
1'!$C$7:$NF$372,25,IF($O$2="Tuesday",VLOOKUP($F$2, '[Heart Rate.xlsx]Week
1'!$C$7:$NF$372,26,IF($O$2="Wednesday",VLOOKUP($F$ 2,'[Heart Rate.xlsx]Week
1'!$C$7:$NF$372,27))))))

This works fine when I enter Monday in cell O2 but returns FALSE when I
enter Tuesday or Wednesday.

Could anyone suggest a way to enhance the formula to make it work?

Kind regards,

Ant