A
Anto111
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
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