Forum Discussion
Implicit intersection operator: @ breaking my formulas
Contrary to Microsoft claiming: " It's important to note that your formulas will continue to calculate the same way they always have.", this is not the case. The introduction of the @ symbol in versi...
dakuhlke Did you try replacing the INDEX(MATCH()) nesting with a simple VLOOKUP()? Something like this:
=IF(I17<>"Target Season","",IF(IFERROR(VLOOKUP($BW17,'Lock @ Style-Country'!A:AH,34,FALSE),"")<>"",VLOOKUP($BW17,'Lock @ Style-Country'!A:AH,34,FALSE),$G17))I also got rid of that IF($G17="","",$G17) because maybe I'm missing something but that doesn't do anything.