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: 42
Default Going CRAZY with INDEX and Match Function

First off let me see if I can even explain this.
I have a workbook with 2 tabs. The first tab is the Origin which list an
Origin City and State abbreviations and a Destination City and State
abbreviations. The second tab is a Matrix which in the first column lists
state abbreviation and the top row lists state abbreviations as well and the
data of rates to charge.

What I am trying to do is create a formula that will look at the state to
state abbreviations on my Origin worksheet and match it up on the Matrix
worksheet state to state abbreivation and return the value where the two
states meet.

I used the following formual which is working for some but not others:
=INDEX(Matrix!$C$5:$BL$65, MATCH(B380,Matrix!$B$5:$B$65,0),
MATCH(D380,Matrix!$C$3:$BL$3,0))

I am beginning to be at a loss!!! Any help would be appreciated.
Sandi Gardner
 
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 Function Question excelnewbie44 Excel Discussion (Misc queries) 4 October 4th 06 10:57 PM
Index? Match? Function to sort and return value fr diff column in Smurfette Excel Worksheet Functions 6 April 27th 06 05:46 PM
Function Vlookup, Match or Index? Patrick Young Excel Worksheet Functions 0 October 3rd 05 11:08 PM
Complicated Index Match Offset function Bob Excel Worksheet Functions 6 September 5th 05 03:01 PM
Need help on index and match function Susan Hayes Excel Worksheet Functions 2 December 22nd 04 10:31 PM


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