View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 71
Default 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.