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