LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MRR MRR is offline
external usenet poster
 
Posts: 7
Default Index / Match in formula

I'm using a formula to compare two cells to an "index table" to determine a
value as follows:

=INDEX(Grid!$B$2:$CL$90,MATCH(D16,Grid!$B$2:$CL$2, 1),MATCH(D17,Grid!$B$2:$B$90,1))

My issue is that sometimes the formula works and gives me the correct value,
but sometimes it looks up "D17" on B2:CL2 and "D16" on B2:B90 -- basically
it's reversing where the match matches. Does anyone know why it does this?
I'm not finding a "method to the madness"; it's just sporadic.
 
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 and Match Formula Barbara Schneier Excel Worksheet Functions 4 January 7th 07 06:07 PM
Index/ Match Formula LJoe Excel Worksheet Functions 2 June 22nd 06 06:19 PM
lookup? Index? match? formula Richard Excel Discussion (Misc queries) 4 February 22nd 06 01:50 AM
Index and Match Array formula Graham Haughs Excel Worksheet Functions 4 February 16th 06 01:51 AM
need help with Index, Match and Countif in the same complicated formula HGood Excel Discussion (Misc queries) 0 February 3rd 05 05:34 PM


All times are GMT +1. The time now is 07:32 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"