Match more than one entry

[HWL]

Okay what I have are 2 lists. In list #1 I have a country code (such as US, MX, FR) and in list #2 I have other data. I can use the country code in list #1 to match list #2 to return the data.

I understand how to return the first match it finds but I want to be able to dragdown a column in list #1 to display the multiple (all really) matches in list #2. I know this will require ctrl-shift-enter somehow but I need help.

Thanks

 

[T. Valko]

Okay I'm all most there but powers that be put a bug in what I'm trying to do. I'm okay as long as I am matching country pair to country pair but there are actually 3 criteria.

ct-to-ct (which Valko solved)
all-to-ct
ct-to-all

I tried an OR statement but the problem is if one of the critera isn't met it breaks with a #NUM issue.
Am I making sense?

Can you post some sample data along with an explanation of what you want to do?

 

[gmaboing]

Can you post some sample data along with an explanation of what you want to do?

Thank you everyone, but I ended up going a different route. I needed an answer right away and figured another way to get the answer I was looking for.

Again, thank you.

 

[T. Valko]

Thank you everyone, but I ended up going a different route. I needed an answer right away and figured another way to get the answer I was looking for.

Again, thank you.

OK, thanks for feeding back!

 

[HWL]

Can you post some sample data along with an explanation of what you want to do?

Hmmm, this may be difficult to explain. I work for a transportation company that has a spreadsheet with all of our rates, then another with "surcharges". On the surcharge sheet, I'm combining 2 columns into one to make it easier to match.

There are 4 possible ways to match:
1. country-to-country
2. all-to-country
3. country-to-all
4. all-to-all

The only way I can figure is Google docs:
https://spreadsheets.google.com/spr...GYB70dDlKbjNmZEZINDViZkM1UWhJQWFrbkE&hl=en_US

See my combination cell in column B. If there is way to look right at columns C & D without having the helper column of B, that would even be better. The code you pointed me to is on another sheet not uploaded to Google Docs.

Thanks