Extract Data from Matrix

**woebegone** · 06-22-2008, 07:53 PM

Greetings:

I'm sorry to just jump in with my problem, but I'm not even sure what to call what I'm trying to do, so just let me ask...

I'm running a small messenger company and I've got a geographic area divided into five zones: 1,2,3E,3W,& 4

Deliveries within 1 zone will be charged for one zone.
Deliveries from Zone 1 to Zone 2 will be charged for 2 zones. Etc.

I've got a list of zones in my From column and also in my To column.

I need to write a formula that will give my customers the Zones Charged in a seperate cell.

I learned how to do something like this back in school, but don't even know what to call it anymore. Maybe it's some kind of comples IF function.

I'd sure appreciate anyone who can help me figure out how to do this.

FREE Deliveries to anyone in Long Beach, CA to the winner!!!

I'm attaching a chart to show what I need done.

Thanx in advance.

Michael Doughty
M&M Messenger

**rylo** · 06-22-2008, 08:53 PM

Hi

Say your matrix as shown is in the range G1:L6. In B2 you have your From Zone, and in C2 you have your To Zone.

The formula: =INDEX(G1:L6,MATCH(B2,G1:G6),MATCH(C2,G1:L1))
should bring back the result from your matrix.

HTH

rylo

**woebegone** · 06-27-2008, 02:15 PM

YES! That was it! Thanx much!

Woe

**woebegone** · 06-27-2008, 05:12 PM

I tried to repeat what (I thought) I'd learned, but this time it's not working.

In cell C36 I have a dropdown list of possible services, Direct, Standard, Same Day, and Overnight.

In cell C37 I have the results of the above matrix calculation 1,2,3, or 4.

It seems like to me that the matrix (See attached) I'm employing should render the resulting prices from the table, but it's not working.

What am I doing wrong?

Wish I'd paid more attention while in school!!

Woebegone

**rylo** · 06-27-2008, 06:19 PM

Hi

Can you please attach a copy of the workbook rather than a picture. Much easier to see what is going on and we don't have to reenter formulas / data.

rylo