I'm struggling to get a SUMPRODUCT formula to work.
Here is the issue:
In the worksheet with the formula A3 = 59438. So, I'm looking for a 59438 in a separate worksheet, holding Table 4, under the "Premises - ID" Header.
There is a 59438 in Table 4, under "Premises - ID". There are...