Oh yes I understand, I'm just not familiar with the semantics of vba coding. Rather than looping it just pastes the formulas down each row then re copies and pastes as values.
The "#" is allowed in the cell as it is formatted as text rather than a formula with an apostrophe in front ('=INDEX etc.)
You are correct there are 4 formulas. The formulas in B2 & B4 are the same with the only difference being the index match search locations are different sheets in the same workbook. Formulas in B3 & B5 are the same except the index match search locations as well, but also uses either the value in column D or column F as the reference. To clarify, the formulas in B2 & B4 search that database via account number (which is the C2 reference) and return the ID of that document. The formulas in B3 & B5 use that Document ID as the reference to pull the date.
I hope this doesnt confuse more but I'll try to upload a sheet with no PII here shortly.
I also tried removing the "#" in each formula and replacing with either C2, D2, or F2. Same overflow error.
Bookmarks