how do I use MATCH to search by zone name in column

[Tim27]

Hi All,

need help with Match function. If I have pricing chart with Zones and weights, how do I use MATCH to search by zone name in column (eg. Zone 123). Goal is to find price based on weight and zone name that are in columns on different sheet. (Zones are marked only as numbers in other sheet.)

Raw data that match function will be matching from:
Weight/Zone
Zone 123 Zone 221
1 x x
2 x x
3 x x
4
5

Data that match function will be looking:
Zone Weight
123 2
331 3
...

Thanks.

[Special-K]

You might want to change the subject of your thread before a mod comes along and asks you for a more detailed subject description and us not to respond until that's done.
Once you done that, post a sample file as it's cnot clear what cells the data is in.

[AliGW]

As you are new to the forum, I have changed your thread title for you this time. In future, you need to make your thread titles explicit. The name of the function you think you need to use is not enough, and actually may not be helpful.

[Tim27]

Hi,

apologies and thank you for explaining the rules. Please find attached example of the sheet with random data.

It has 2 data sheets that formula would have to pull data from.

GOAL is to find price from matrixes based on weight and zone.

Thanks.

[Special-K]

=IFERROR(INDEX('Price sheet 1'!$C$5:$I$34,MATCH(C5,'Price sheet 1'!$B$5:$B$34,0),MATCH("Zone "&B5,'Price sheet 1'!$C$4:$I$4,0)),INDEX('Price sheet 2'!$C$5:$I$34,MATCH(C5,'Price sheet 2'!$B$5:$B$34,0),MATCH("Zone "&B5,'Price sheet 2'!$C$4:$I$4,0)))

copy down the column

NOTE: There's no ZONE 2 in your data hence the #N/A result

Some of your data has recurring numbers like 22.3333333333333 displaying as 22.3

[Tim27]

Thank you for the help!

I have another very similar problem. In att. it's an example of smaller scale.

On sheet1 under column B(Zone), there should be zone number based on country code and data on sheet named Data.

Thanks.

[GeoffW283]

Try on sheet1!B2 and copy down:

Please Login or Register  to view this content.

You'll (correctly) see a fair number of blanks where there is no corresponding country code on the data sheet.