In my Example I have a list of items on a separate sheet. I have a data validation rule that says the items must be selected from my list. I want to be able to run a formula in my Excel sheet that lets me know if the data in the cell is valid. I cannot use any VBA code to do this because I have a new requirement to not use any macros in this worksheet.
Here is the VBA function I had written.
Public Function ISVALID(ByVal Target As Range) As Boolean
ISVALID = Target.Validation.Value
However, I need a way to do this using the current Excel formulas. Any help would be appreciated.