Hello

I have the following formula:

=IF(ISERROR(VLOOKUP($A150,'FURL Data'!$C:$G,3,FALSE)),0,(VLOOKUP
($A150,'FURL Data'!$C:$G,3,FALSE)))

This was working fine, but for some reason my source data has changed
so that the figures I need now span two separate rows, where they were
one before. So the above is no longer working as it only finds the
first row.

Is there an easy way to amend the above, so it finds both rows and
adds them together?

Would be grateful for any assistance!