IF formula based on values in range, returning the title of range

[talrak]

Hi,

tried to search a solution for quite simple scenario, where IF formula should look in values in defined area/name/range and if match found, formula would return area title as value. see attached sample of excel

Screenshot 2021-10-04 at 10.16.34.png

[AliGW]

Your 'larger than 0' in the lookup table is going to be problematic. How many other possible values could there be in the YES and NO columns? Or is this the extent of the issue?

I have a horrible feeling that you are showing us only the tip of the iceberg, and that many twists and turns are to follow, leading to massively shifting goalposts.

In order not to cause massive frustration for your helpers (potentially!), please tell us the whole story up front. Thanks.

[JohnTopley]

Based on the limited sample (as per Ali's response)

=IFERROR(IF(MATCH(F8,INSCOPE,1),$C$6),$D$6)

For ">0" add small number (e.g 0.0001) in your table

[talrak]

Hi,

apologies for not being clear and as you mentioned, I should have defined in more details the other possible values.

The possible values on Yes column: any number higher than 0, "Yes" and other different text values (=words)
The possible values on No column: 0 and "No" and other different text values (=words)

[JohnTopley]

So does offering in post #3 work for you?

[talrak]

Hi John,

that seems to be working solution, thanks for helping me out.

[AliGW]

Thanks for marking this thread as SOLVED.

You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.