|
Formula Issue
Hello from Steve
The below returns the value in D5 the value I require is in D12 {=IF($E$106="Aug",'Trips per Calendar Year'!$D$5:$D$16,0)} my attempt below returns a "0" value. {=IF($E$106=$A$5:$A$16,'Trips per Calendar Year'!$D$5:$D$16,0)} Thankyou |
Formula Issue
I think you mean that as August is the 8th month then you want the 8th
cell from the range D5:D16. Is that correct? Pete On Sep 3, 12:19*am, Steved wrote: Hello from Steve The below returns the value in D5 the value I require is in D12 {=IF($E$106="Aug",'Trips per Calendar Year'!$D$5:$D$16,0)} my attempt below returns a "0" value. {=IF($E$106=$A$5:$A$16,'Trips per Calendar Year'!$D$5:$D$16,0)} Thankyou |
Formula Issue
Hello Pete_UK
In Sheet1 I have the Below E106 I have "Aug" in the "Trips per Calendar Year" Sheet I have the below In cell A5 I have "Jan" In cell A6 I have "Feb" and so on to A16 which has "Dec" In Cell D5 to D16 I have Data Simple put In Col A5:A16 find "Aug" which is located in Cell A12 My Objective please is for the formula to goto D12 which has the Data I require. 8th cell from the range D5:D16. Is that correct? "Yes" In Sheet1 I have the Below E106 I have "Aug" "Pete_UK" wrote: I think you mean that as August is the 8th month then you want the 8th cell from the range D5:D16. Is that correct? Pete On Sep 3, 12:19 am, Steved wrote: Hello from Steve The below returns the value in D5 the value I require is in D12 {=IF($E$106="Aug",'Trips per Calendar Year'!$D$5:$D$16,0)} my attempt below returns a "0" value. {=IF($E$106=$A$5:$A$16,'Trips per Calendar Year'!$D$5:$D$16,0)} Thankyou |
Formula Issue
Okay, you could do it using VLOOKUP like this:
=VLOOKUP(E106,'Trips per calendar year'!A$5:D$16,4,0) Another way would be to use an INDEX/MATCH combination, but it would be longer. Hope this helps. Pete On Sep 3, 12:57*am, Steved wrote: Hello Pete_UK In Sheet1 I have the Below E106 I have "Aug" in the "Trips per Calendar Year" Sheet I have the below In cell A5 I have "Jan" In cell A6 I have "Feb" and so on to A16 which has "Dec" In Cell D5 to D16 I have Data Simple put In Col A5:A16 find "Aug" which is located in Cell A12 My Objective please is for the formula to goto D12 which has the Data I require. 8th *cell from the range D5:D16. Is that correct? "Yes" In Sheet1 I have the Below E106 I have "Aug" "Pete_UK" wrote: I think you mean that as August is the 8th month then you want the 8th cell from the range D5:D16. Is that correct? Pete On Sep 3, 12:19 am, Steved wrote: Hello from Steve The below returns the value in D5 the value I require is in D12 {=IF($E$106="Aug",'Trips per Calendar Year'!$D$5:$D$16,0)} my attempt below returns a "0" value. {=IF($E$106=$A$5:$A$16,'Trips per Calendar Year'!$D$5:$D$16,0)} Thankyou- Hide quoted text - - Show quoted text - |
Formula Issue
I Thankyou.
"Pete_UK" wrote: Okay, you could do it using VLOOKUP like this: =VLOOKUP(E106,'Trips per calendar year'!A$5:D$16,4,0) Another way would be to use an INDEX/MATCH combination, but it would be longer. Hope this helps. Pete On Sep 3, 12:57 am, Steved wrote: Hello Pete_UK In Sheet1 I have the Below E106 I have "Aug" in the "Trips per Calendar Year" Sheet I have the below In cell A5 I have "Jan" In cell A6 I have "Feb" and so on to A16 which has "Dec" In Cell D5 to D16 I have Data Simple put In Col A5:A16 find "Aug" which is located in Cell A12 My Objective please is for the formula to goto D12 which has the Data I require. 8th cell from the range D5:D16. Is that correct? "Yes" In Sheet1 I have the Below E106 I have "Aug" "Pete_UK" wrote: I think you mean that as August is the 8th month then you want the 8th cell from the range D5:D16. Is that correct? Pete On Sep 3, 12:19 am, Steved wrote: Hello from Steve The below returns the value in D5 the value I require is in D12 {=IF($E$106="Aug",'Trips per Calendar Year'!$D$5:$D$16,0)} my attempt below returns a "0" value. {=IF($E$106=$A$5:$A$16,'Trips per Calendar Year'!$D$5:$D$16,0)} Thankyou- Hide quoted text - - Show quoted text - |
Formula Issue
You're welcome, Steve - thanks for feeding back.
Pete On Sep 3, 2:22*am, Steved wrote: I Thankyou. "Pete_UK" wrote: Okay, you could do it using VLOOKUP like this: =VLOOKUP(E106,'Trips per calendar year'!A$5:D$16,4,0) Another way would be to use an INDEX/MATCH combination, but it would be longer. Hope this helps. Pete On Sep 3, 12:57 am, Steved wrote: Hello Pete_UK In Sheet1 I have the Below E106 I have "Aug" in the "Trips per Calendar Year" Sheet I have the below In cell A5 I have "Jan" In cell A6 I have "Feb" and so on to A16 which has "Dec" In Cell D5 to D16 I have Data Simple put In Col A5:A16 find "Aug" which is located in Cell A12 My Objective please is for the formula to goto D12 which has the Data I require. 8th *cell from the range D5:D16. Is that correct? "Yes" In Sheet1 I have the Below E106 I have "Aug" "Pete_UK" wrote: I think you mean that as August is the 8th month then you want the 8th cell from the range D5:D16. Is that correct? Pete On Sep 3, 12:19 am, Steved wrote: Hello from Steve The below returns the value in D5 the value I require is in D12 {=IF($E$106="Aug",'Trips per Calendar Year'!$D$5:$D$16,0)} my attempt below returns a "0" value. {=IF($E$106=$A$5:$A$16,'Trips per Calendar Year'!$D$5:$D$16,0)} Thankyou- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com