Google Sheets Formula

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

Skills: Google Sheets

See more: google pays 150 hour, please wait will redirected script php, please tell will fin, script update cell google sheets, google sheets calendar integration, programming google sheets, excel convert google sheets, google sheets, hire data entry freelance google sheets, i am looking for someone to write a google apps script in google sheets, looking for a developer working with google sheets, need programmer for google sheets, google sheets and, google sheets api, google sheets desktop, google sheets help, google sheets how to, google sheets online, google sheets scripts, google sheets formula

About the Employer:
( 27 reviews ) Brisbane, Australia

Project ID: #21701699

Awarded to:


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.

$30 AUD in 1 day
(0 Reviews)

2 freelancers are bidding on average $27 for this job


Hello. My name is Alejandra Baptista I am an accountant, administrator and financial graduated. I am very fast typing and good in redaction or transcription. I have a lot experience with Excel, Power Point, Word, SPSS More

$23 AUD in 1 day
(0 Reviews)