There are hundreds of intersecting cells where I go in manually and change the cell value to 0. It seems so simple
(Lookup X and Y, Where they meet; change to 0)
I know you can do 2 way lookups but I don't actually need to know the value of the intersecting cells.
Apologies for wording this poorly...does anybody have a solution to this issue?
Thank you.
Bookmarks