Hello, I am currently using the following formula and it is causing massive lag on my sheet.
=IF(ISNUMBER(XMATCH($A3&C$1,'LIST'!$A:$A&'LIST'!$B:$B)),"X","")
It becomes basically unusable to the point where i turned auto calculations off. Is there a better cleaner way to reach my desired result that wont slow down the file?
Here is an example of the data that I have. This has been shortened, the true table has roughly 1000 each of TYPE and COLOR that will continue to grow. I think the large volume of IF statements is cause of the slowdown.
This would be the desired result
Any helpwith this would be greatly appreciated!!
=IF(ISNUMBER(XMATCH($A3&C$1,'LIST'!$A:$A&'LIST'!$B:$B)),"X","")
It becomes basically unusable to the point where i turned auto calculations off. Is there a better cleaner way to reach my desired result that wont slow down the file?
Here is an example of the data that I have. This has been shortened, the true table has roughly 1000 each of TYPE and COLOR that will continue to grow. I think the large volume of IF statements is cause of the slowdown.
This would be the desired result
Any helpwith this would be greatly appreciated!!
