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

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

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

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 -

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 -

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 -