I've created this formula =if(E4=Sheet2!C$2:C$43,"Option 1","Option 2")
The goal is to compare cell E4 against a range of values in Sheet2 column C
However, it appears to only be compared against C2
Will grant access to the Google sheet to fix
Please mention the word 'banana' in your reply to show you've read this.
I'm looking for someone to solve this in the next hour
Hello banana, I’m a Google Sheets expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.