LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula INDEX/MATCH MadMax Excel Worksheet Functions 1 February 2nd 07 04:48 PM
Index / Match in formula MRR Excel Worksheet Functions 2 January 10th 07 05:52 PM
Index and Match Formula Barbara Schneier Excel Worksheet Functions 4 January 7th 07 06:07 PM
Need Help w/ Index and Match Formula japorms Excel Worksheet Functions 1 July 10th 06 09:57 PM
How do I display more than one match in a Index/Match formula? Trish Excel Worksheet Functions 0 September 26th 05 10:21 PM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"