Recent Questions - Web Applications Stack Exchange · Apr 12, 2022
This page did not load. You can still read it on the original site — the toolbar below keeps your place in the directory.
I'm trying to create an if formula to look at an entire column and if it matches a number of rows then add the value_if_true. So I want to look at the entire column C to see if there is a match to column B rows 2-20 then input the true value but leave blank if false. When I use the following formula I'm just getting a error, the array value cannot be found. How do I need to adjust this or is this…
I'm trying to create an if formula to look at an entire column and if it matches a number of rows then add the value_if_true. So I want to look at the entire column C to see if there is a match to column B rows 2-20 then input the true value but leave blank if false. When I use the following formula I'm just getting a error, the array value cannot be found. How do I need to adjust this or is this even the right formula?
=IF(C:C=B2:B20,"Yes",)
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.