0

In an excel workbook, I have two spill ranges. I want a third column that will return "1" if the same value occurs in both spill ranges. Normally, I would write a formula like

=IF(T3='Timeliness Issues'!J:J,1,"")

T3 is one spill range and the J column is the other. However, I keep getting a #SPILL error. I assume I need to add something to the formula so that it only looks at the returned value in the spill range and not the formula?

Any suggestions are appreciated!

jillingworth
  • 3
  • 2
  • 1
    `=--ISNUMBER(MATCH(T3#,J:J,0))` Make sure you delete all formula and values in the cells below this formula as it will spill the results. – Scott Craner Feb 15 '23 at 18:59

0 Answers0