Index/Match formula

[Chris]

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 e1313
In e1515 I have another value that corresponds with the same number
in e1313 and is in the same column

In T2, I would like to have the value from e1515 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.

 

[T. Valko]

It sounds like you should be able use this:

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

 

[Chris]

It sounds like you should be able use this:

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

--
Biff
Microsoft Excel MVP









- Show quoted text -

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

 

[T. Valko]

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

It sounds like you should be able use this:

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

--
Biff
Microsoft Excel MVP









- Show quoted text -

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

 

[Chris]

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

Try this:

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

--
Biff
Microsoft Excel MVP






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

- Show quoted text -

Thanks man, you rock!

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

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

Try this:

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

--
Biff
Microsoft Excel MVP






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

- Show quoted text -

Thanks man, you rock!