LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 247
Default Index & Match doesn't seem to work

Copied function shown below to new worksheet.
Range name was created (to match)
Table layout is identical to original

TABLE (part of) called Angle_Table

Overhang
Length 6 9 12 15 18 21 24
12 44.9 46.0 47.2 48.4 49.7 51.1 52.5
12.5 42.8 43.8 44.9 46.0 47.2 48.4 49.7
13 45.2 46.3 47.3 48.5 49.6 50.9 52.2
13.5 47.5 48.5 49.6 50.8 51.9 53.2 54.5

=INDEX(LUps_2!Angle_Table,MATCH(E6,INDEX(LUps_2!An gle_Table,,1),0),MATCH(E12,INDEX(LUps_2!Angle_Tabl e,1,),0))

I added the sheet Name (LUps_2) to make sure it would go to the correct W/S,
but originally that was not required.

E6 is where the Length is Specified
E12 is where the Overhang Length is specified.
Result should be the intersect of the two.

Please advise what (simple?) thing I'm overlooking here.
Unforunately, I do not understand what all the "extra" commas are all about.

 
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
INDEX, MATCH, IF function does not work Michael[_7_] Excel Worksheet Functions 3 November 7th 09 04:40 AM
Find Exact Match using INDEX, MATCH DoubleUU Excel Worksheet Functions 3 August 15th 08 02:42 PM
index(match) Wind Uplift Calculations (match four conditions) JMeier Excel Worksheet Functions 8 August 1st 08 01:45 AM
index match array function-returning only first match, need last. Julie Olsen Excel Worksheet Functions 3 December 29th 06 12:50 AM
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 02:43 AM.

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"