Source information from different sheets with vlookup

G

GijsKijlstra

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 'lates
version NUMBERS', when data not found, go to 'v46 NUMBERS', when dat
not found go to Ingestion. In specific:
=IF(ISERROR(VLOOKUP($E4&"*",'latest versio
NUMBERS'!$E$4:$V$653,4,0)),VLOOKUP($E4&"*",'latest versio
NUMBERS'!$E$4:$V$653,4,0),
IF(ISERROR(VLOOKUP($E4&"*",'v4
NUMBERS'!$E$4:$V$653,4,0)),VLOOKUP($E4&"*",'v4
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 formul
and removed the data from h4 in 'latest version NUMBERS' the formula di
NOT return the available data from 'v46 NUMBERS' but from shee
Ingestion.

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

Gij
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup from different sheets 2
Help with a running total on multiple sheets 2
vlookup from multiple sheets 2
vlookup 1
VLOOKUP Errors with Date formats 1
How to list cells from two sheets that has different values in theirneighboring column? 8
Help: vlookup from multiple sheets and spreadhseets 1
Hlookup/Vlookup with duplicate datas 0

Top