Forum Discussion
Excel formulaqs and functions
I am trying to transfer data from one master file to another sub file(tab) within the same file, using the formula: =INDEX(Master!$A4:$A$2400,MATCH($A$35,Master!$C4:$C$2400,""),1)
where col A4 contains certain data, and if true, pulls the match from Master file to the sub file in cell A35, and it works. The formula bar also automatically replaced this formula with:
=IF(Master!$C17="D1",Master!A17,"") and both work.
The problem is that if the condition is not met (C17 <> "D1"), it generates a blank (or other desired FALSE statement )in the cell, RATHER THAN NOTHING AT ALL. Due to the voluminous times the TRUE condition will not be met, I have to subsequently delete all the row cell data with "" (or other FALSE data in that cell.
Is there a convenient way to only transfer data when the true condition is found, and do nothing if false???
Many thanks!
22 Replies
Nope, formulas are always return some value, "do nothing" is only with VBA programming.
SergeiBaklan Thx Sergio. Might there be a way to merge all the rows with data and w/o data(blanks) so that I only have rows with the data I want and not multiple rows of blanks?? The Filter function does it, but doesn't seem to retain/save the merged/filtered data (w/o blanks)nor permit additional calculations while in the filter mode. Thx for your help.
You may use INDEX/MATCH with criteria, but I didn't catch what exactly do you compare. If you may submit small sample file without sensitive information that will be easier.
