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!
Bookmarks