Source information from different sheets with vlookup
 

I have a sheet that sources information from three other sheets:
* 'latest version NUMBERS'
* 'v46 NUMBERS' and
* Ingestion

These three sheets have been developed over time:
* 'latest version NUMBERS' being the most recent data;
* 'v46 NUMBERS' in the middle and
* Ingestion carrying the oldest data,
To further complicate matters, the sheets are not equally complete.

I’ve developed a vLookup formula that states: check first 'latest version NUMBERS', when data not found, go to 'v46 NUMBERS', when data not found go to Ingestion. In specific:
=IF(ISERROR(VLOOKUP($E4&"*",'latest version NUMBERS'!$E$4:$V$653,4,0)),VLOOKUP($E4&"*",'latest version NUMBERS'!$E$4:$V$653,4,0),
IF(ISERROR(VLOOKUP($E4&"*",'v46 NUMBERS'!$E$4:$V$653,4,0)),VLOOKUP($E4&"*",'v46 NUMBERS'!$E$4:$V$653,4,0),
VLOOKUP($E4&"*",Ingestion!$G$4:$AA$737,10,0)))

So far, so good. At least so I thought. But, when I tested the formula and removed the data from h4 in 'latest version NUMBERS' the formula did NOT return the available data from 'v46 NUMBERS' but from sheet Ingestion.

Any thoughts on how I can resolve this? Thank you in advance,

Gijs