Lookup Based on Position and Condition

Hi,

I asked a similar question earlier and someone very kindly helped almost immediately.

The solution worked perfectly with the sample data that I provided but didn't seem to work when I applied it to the real data.

Also, I didn't understand what the formula was doing so couldn't amend it.

So I've attached a better representation of my data in the hope that someone can please help?

If product code AAA is in J2 I would like to create a formula in K2 that will return the Country name (from column D) for the row of product AAA that has a non-zero value in E:H closest to the final column in the range. In my example, "Germany" will be returned by the formula as AAA has a non-zero value closest to column H for that country.

Hope that makes sense!

Thanks!

Administrative Note:

This is just a continuation of the same topic, so is a duplicate thread, and you know you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...onditions.html