Forum Discussion
How to combine IF OR functions
So I want to do the following: 1 cel has a dropdown of 3 items in another cell I want to say: if option A then 1 comes out if option B then 2 comes out if option 3 then 3 comes out How do I...
A newer function that replaced MATCH in 365:
= XMATCH(selected, validationList)The 'exact match' is now the default. The defined names can be chosen according to the context.