Hi,

so I would need a formula that can be applied from columns D - K and look in column B first and bring back dates, then look in Column A and bring back dates. Reason being, that it may not always be in column H where dates need to brought back for a new site number, it could be in any of them e.g. an old site only has one date (column D) and then from column E onwards dates should be brought back relating to the new site if that makes sense?

Essentially, a site could change number at any time in the year. Also, visits aren't always monthly, they could be quarterly, every 2 months etc (so there's no set pattern to follow).
As such, the same logic applies to columns M-T - that it needs to be able to read the site numbers in both column B and A.


So the ammended formula does now work in bringing back the dates in red, but is there a way to combine this with your initial formula, so that across the whole section, the formula looks at both the old and new sites?

Thanks again for your help though !!