Getting values from multiple rows and colums

**BILAL336** · 07-10-2012, 02:44 PM

Hello:

Ive attached an excel spreadsheet that includes some rates and zones for my contractor. I already have a Data Validation list setup where if i select a specific postal code it provides me the Zone that you can see on the top of the attached spreadsheet.

What im trying to do is as below:

If for example i selected the postal code in Cell "S3" using the data validation list as "A0A", the zone is displayed using the vlookup statement as "D13" in cell "T4". and then i select the total weight using data validation list in cell "U4" as "9" then i need a formula that can display the value from cell "N10". The formula that i need is something so that whatever the postal code or weight i select it should display the value from the corresponding Zone (Column) and Weight (Row).

Can anyone help?

Thx, Bilal336

**Ace_XL** · 07-10-2012, 03:18 PM

Try this...

=INDEX($A$1:$Q$152,MATCH(U3,$A$1:$A$152,0),MATCH(T3,$A$1:$Q$1,0))

**K m** · 07-10-2012, 03:29 PM

Enter this formula in cell T5:

=VLOOKUP(U3,A2:Q152,VALUE(+RIGHT(T3,2))+1)

What this does:
- Using U3 {Weight}
- and this table A2:Q152
- Which value corresponds to this column, VALUE(+RIGHT(T3,2))+1) {For example D13 is in column 14}

Mark this as [SOLVED] if this answers your problem and click on the star below

**BILAL336** · 07-10-2012, 03:55 PM

Absolutely awesome, worked for me, i had another detailed sheet but worked!!! Thanks alot for the help.

Thats what i used: =INDEX('Provinces and Products'!N1:AD152,MATCH(B30,'Provinces and Products'!N$1:$N$151,0),MATCH(D4,'Provinces and Products'!N$1:$AD$1))

**Cutter** · 07-10-2012, 05:35 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save