Index/Match formula
 

I am not sure what type of formula I should be using for the
following, but I can't use an array entered formula or the column or
row functions and was hoping to solve the below with a simple index/
match/offset formula:

In S2 I have a number
I have the same number that I have in S2 somewhere in e13:o13
In e15:o15 I have another value that corresponds with the same number
in e13:o13 and is in the same column

In T2, I would like to have the value from e15:o15 that is matched
with S2 and the same number 2 rows above in e13:013.

Any help with the proper formula (that excludes an array formula ar a
formula using column or Row functions - I can't use these as my excel
logic gets inputted into another proggy that doesn't like those) would
be greatly appreciated.

Index/Match formula
 

It sounds like you should be able use this:

=SUMIF(E13:O13,S2,E15:O15)

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
I am not sure what type of formula I should be using for the
following, but I can't use an array entered formula or the column or
row functions and was hoping to solve the below with a simple index/
match/offset formula:

In S2 I have a number
I have the same number that I have in S2 somewhere in e13:o13
In e15:o15 I have another value that corresponds with the same number
in e13:o13 and is in the same column

In T2, I would like to have the value from e15:o15 that is matched
with S2 and the same number 2 rows above in e13:013.

Any help with the proper formula (that excludes an array formula ar a
formula using column or Row functions - I can't use these as my excel
logic gets inputted into another proggy that doesn't like those) would
be greatly appreciated.

Index/Match formula
 

On Sep 18, 2:01*pm, "T. Valko" wrote:
It sounds like you should be able use this:

=SUMIF(E13:O13,S2,E15:O15)

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...



I am not sure what type of formula I should be using for the
following, but I can't use an array entered formula or the column or
row functions and was hoping to solve the below with a simple index/
match/offset formula:

In S2 I have a number
I have the same number that I have in S2 somewhere in e13:o13
In e15:o15 I have another value that corresponds with the same number
in e13:o13 and is in the same column

In T2, I would like to have the value from e15:o15 that is matched
with S2 and the same number 2 rows above in e13:013.

Any help with the proper formula (that excludes an array formula ar a
formula using column or Row functions - I can't use these as my excel
logic gets inputted into another proggy that doesn't like those) would
be greatly appreciated.- Hide quoted text -

- Show quoted text -

It returns a value of 0 where it should be an actual word

Index/Match formula
 

It returns a value of 0 where it should be
an actual word

Ok, I thought there were numbers in E15:O15.

Try this:

=INDEX(E15:O15,MATCH(S2,E13:O13,0))

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
On Sep 18, 2:01 pm, "T. Valko" wrote:
It sounds like you should be able use this:

=SUMIF(E13:O13,S2,E15:O15)

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...



I am not sure what type of formula I should be using for the
following, but I can't use an array entered formula or the column or
row functions and was hoping to solve the below with a simple index/
match/offset formula:

In S2 I have a number
I have the same number that I have in S2 somewhere in e13:o13
In e15:o15 I have another value that corresponds with the same number
in e13:o13 and is in the same column

In T2, I would like to have the value from e15:o15 that is matched
with S2 and the same number 2 rows above in e13:013.

Any help with the proper formula (that excludes an array formula ar a
formula using column or Row functions - I can't use these as my excel
logic gets inputted into another proggy that doesn't like those) would
be greatly appreciated.- Hide quoted text -

- Show quoted text -

It returns a value of 0 where it should be an actual word

Index/Match formula
 

On Sep 18, 2:36*pm, "T. Valko" wrote:
It returns a value of 0 where it should be
an actual word

Ok, I thought there were numbers in E15:O15.

Try this:

=INDEX(E15:O15,MATCH(S2,E13:O13,0))

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...
On Sep 18, 2:01 pm, "T. Valko" wrote:





It sounds like you should be able use this:

=SUMIF(E13:O13,S2,E15:O15)

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...

I am not sure what type of formula I should be using for the
following, but I can't use an array entered formula or the column or
row functions and was hoping to solve the below with a simple index/
match/offset formula:

In S2 I have a number
I have the same number that I have in S2 somewhere in e13:o13
In e15:o15 I have another value that corresponds with the same number
in e13:o13 and is in the same column

In T2, I would like to have the value from e15:o15 that is matched
with S2 and the same number 2 rows above in e13:013.

Any help with the proper formula (that excludes an array formula ar a
formula using column or Row functions - I can't use these as my excel
logic gets inputted into another proggy that doesn't like those) would
be greatly appreciated.- Hide quoted text -

- Show quoted text -

It returns a value of 0 where it should be an actual word- Hide quoted text -

- Show quoted text -

Thanks man, you rock!

Index/Match formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
On Sep 18, 2:36 pm, "T. Valko" wrote:
It returns a value of 0 where it should be
an actual word

Ok, I thought there were numbers in E15:O15.

Try this:

=INDEX(E15:O15,MATCH(S2,E13:O13,0))

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...
On Sep 18, 2:01 pm, "T. Valko" wrote:





It sounds like you should be able use this:

=SUMIF(E13:O13,S2,E15:O15)

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...

I am not sure what type of formula I should be using for the
following, but I can't use an array entered formula or the column or
row functions and was hoping to solve the below with a simple index/
match/offset formula:

In S2 I have a number
I have the same number that I have in S2 somewhere in e13:o13
In e15:o15 I have another value that corresponds with the same number
in e13:o13 and is in the same column

In T2, I would like to have the value from e15:o15 that is matched
with S2 and the same number 2 rows above in e13:013.

Any help with the proper formula (that excludes an array formula ar a
formula using column or Row functions - I can't use these as my excel
logic gets inputted into another proggy that doesn't like those) would
be greatly appreciated.- Hide quoted text -

- Show quoted text -

It returns a value of 0 where it should be an actual word- Hide quoted
text -

- Show quoted text -

Thanks man, you rock!