Looking for Range in Logical Test of IF statement

[stevman22889]

Hello,

I am having issues with an if statement. Instead of using something absolute (aka, =if(cell1=cell2,)), I need a way to include a range. I need the logical test part of the statement to search for whether or not that specific value is within a range, rather than looking for whether it equals a specific cell/column.

Basically, I want to use something like this =if(cellA value is in columnB),1,"").

I know it's probably pretty easy, but I am struggling to figure out how I can pull this off. Any help is greatly appreciated!

 

[FormR]

Hi Welcome to the Forum!

You could try - for example:

=IF(ISNUMBER(MATCH(A1,B:B,0)),1,"")