|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Source information from different sheets with vlookup
I have a sheet that sources information from three other sheets:
* 'latest version NUMBERS'
* 'v46 NUMBERS' and
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),
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,
|Thread||Thread Starter||Forum||Replies||Last Post|
|Pivot Table - Source Data Information||MSweetG222||Excel Programming||2||July 10th 09 08:12 PM|
|How do I use auto fill to add information from an existing source?||Jamie Thompson[_2_]||New Users to Excel||1||December 8th 08 10:39 PM|
|How I do protect linked information if the link source is deleted||moran||Excel Worksheet Functions||2||October 25th 06 08:07 PM|
|Reading the Clipboard Source Information||TCook||Excel Programming||0||October 9th 05 04:49 AM|
|Help needed coding a macro to adjust the source of information each time it is run||lbauckman||Excel Programming||1||November 4th 03 08:13 AM|