Excel Forum

Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples

Learn about array syntax with the OR function. See three different ways to check if a Product ID prefix matches our companies three digits prefix. Learn about when Ctrl + Shift + Enter is required for the OR function and when it is not required see that array syntax can be used with the OR function to avoid an array formula that requires Ctrl + Shift = Enter. See OR and LEFT functions.

Got a Question? Ask it Here in the Forum.