Excel "IF" - formula

[Johnnie91]

Hi, 

  Im having some issues about IF formula for specified number matching as the picture attached, its become "spill error" after replicated the formula from the cell N7 instead of True/ False statement. Do anyone know how to solve this ? Thanks 


 

[#2]

@Johnnie91 

It depend on what you'd like to compare. If each number in D to the value in same row from column K, then enter in N7  

=K7:K77=D7:D77

[#3]

Active N7,then type this formula =IF(K7=D7:D10,"TRUE","FALSE")

[#4]

@Mubeen2045 

It will also return #SPILL! error if you drag it down

[#5]

@Sergei Baklan  The number goes randomly, not all are same arrayed. Thus, I try to use excel assist on which one is matching which is not.   

[#6]

Exactly, I got no idea how to solve on this =(

[#7]

@Johnnie91 

Sorry, I didn't catch. You'd like to check

1) if K7 is met at any position in column D, same for K8, etc.; or

2) if K7=D7; K8=D8; etc.

If the first that will =ISNUMBER(MATCH(K7,$D7:$D99,0))

[#8]

I would like to know if K7 is met at any position in column D, same for K8, K9 and etc. But when was dragged & copy the formula it show false even though the number is matching for K8, K9.

[#9 · Accepted solution]

@Johnnie91 

In my case it works

[#10]

Appreciated for the suggestion, I tried. It works well... =)

[#11]

@Johnnie91 , you are welcome, glad to help