Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula INDEX/MATCH | Excel Worksheet Functions | |||
Index / Match in formula | Excel Worksheet Functions | |||
Index and Match Formula | Excel Worksheet Functions | |||
Need Help w/ Index and Match Formula | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions |