Returning Value from Named List - IF(ISNUMBER(MATCH not working!

[i3 Data Hound]

Hey All,

I have a named list entitled "OutsideSectorID", this list contains the values: 0, 5551,5552,5553,5554,5555,5556.

Within my table I have a column for Sector ID in which a wide range of number values appear. Within a separate column I need the values to return as "Outside" if the corresponding value in Sector ID matches any value within the list "OutsideSectorID", and return the value as "Inside" if it does not match any values within that list.

I have used the formula: =IF(ISNUMBER(MATCH('SectorID_Cell',OutsideSectorID,0)),"Outside","Inside") however every value is returning as "Inside". What I can't figure out is why this formula is not working for this when it is working for other list functions in the exact same way. The only difference is that this list is all numeric values whereas all my other lists contain text values.

Any assistance is greatly appreciated!

*Update* I figured it out: =IF(ISNUMBER(MATCH(VALUE('SectorID_Cell'),OutsideSectorID,0)),"Outside","Inside")

[Pepe Le Mokko]

Thanks for sharing your solution

FYI you can drop the ISNUMBER function

Please Login or Register  to view this content.