Salimander
New Member
- Joined
- Sep 25, 2020
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi everyone, I need some assistance with a formula. I'm trying to look up if a specific value exists in a specific column, but I'm having difficulty with the formula. I used a different formula to get my answer but I just want to understand why my formula wasn't originally working. It says the lookup array is in red.
=if(match(A1,$C$1:$C$100,0)"YES")
here is my formula. I would appreciate any help if I made any mistakes would you be able to tell me what I did wrong as I'm trying to learn how to do things without having to look it up. Thank you in advance!
=if(match(A1,$C$1:$C$100,0)"YES")
here is my formula. I would appreciate any help if I made any mistakes would you be able to tell me what I did wrong as I'm trying to learn how to do things without having to look it up. Thank you in advance!