Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if and Vlookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if and Vlookup
=IF($O$2="Monday",VLOOKUP($F$2,'[Heart Rate.xlsx]Week
1'!$C$7:$NF$372,25,False),IF($O$2="Tuesday",VLOOKU P($F$2,'[Heart Rate.xlsx]Week 1'!$C$7:$NF$372,26,False),IF($O$2="Wednesday",VLOO KUP($F$2,'[Heart Rate.xlsx]Week 1'!$C$7:$NF$372,27,False))) "Anto111" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if and Vlookup
Brilliant! Looks like its working.
Many thanks Dennis, much appreciated. "Dennis" wrote: =IF($O$2="Monday",VLOOKUP($F$2,'[Heart Rate.xlsx]Week 1'!$C$7:$NF$372,25,False),IF($O$2="Tuesday",VLOOKU P($F$2,'[Heart Rate.xlsx]Week 1'!$C$7:$NF$372,26,False),IF($O$2="Wednesday",VLOO KUP($F$2,'[Heart Rate.xlsx]Week 1'!$C$7:$NF$372,27,False))) "Anto111" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if and Vlookup
If you're only wanting to test for Mon, Tue and Wed...
=VLOOKUP($F$2,'[Heart Rate.xlsx]Week 1'!$C$7:$NF$372,24+MATCH($O$2,{"Monday","Tuesday", "Wednesday"},0),0) -- Biff Microsoft Excel MVP "Anto111" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with Multiple criteria and multiple sheets | Excel Worksheet Functions | |||
Vlookup for multiple criteria, multiple worksheets | Excel Worksheet Functions | |||
vlookup multiple corresponding | Excel Discussion (Misc queries) | |||
Multiple VLOOKUP | Excel Worksheet Functions | |||
How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) |