Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
Hi all,
I have this formula I found online:
I have now set the formula to test if my value "test" in cell B2 is located anywhere at all in within the value set B1:D133 in sheet 2.
I literally have the value "test" in cell B2, but it does not work:
It should return the value "1" if the value is in sheet 2.
Any idea why my formula is not working? Would greatly appreciate some help here!
Thank you all
Best regards,
Jyggalag
I have this formula I found online:
I have now set the formula to test if my value "test" in cell B2 is located anywhere at all in within the value set B1:D133 in sheet 2.
I literally have the value "test" in cell B2, but it does not work:
It should return the value "1" if the value is in sheet 2.
Any idea why my formula is not working? Would greatly appreciate some help here!
Thank you all
Best regards,
Jyggalag