I am trying to get a formula into a worksheet which looks like the following;
=IF(ISNA(VLOOKUP(O29,DATABASE!A:S,3,FALSE)),"",VLOOKUP(O29,DATABASE!A:S,3,FALSE))
I have tried this;
'ActiveCell.FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC[-1],DATABASE!R2C1:R65536C19,3,FALSE)),"",VLOOKUP(RC[-1],DATABASE!R2C1:R65536C19,6,FALSE))"
but it doesnt work as the quotes in the middle of the if statement to return a blank cell cause an error. How can I get a blank cell if the ISNA is true ?
THANKS
=IF(ISNA(VLOOKUP(O29,DATABASE!A:S,3,FALSE)),"",VLOOKUP(O29,DATABASE!A:S,3,FALSE))
I have tried this;
'ActiveCell.FormulaR1C1 = "=IF(ISNA(VLOOKUP(RC[-1],DATABASE!R2C1:R65536C19,3,FALSE)),"",VLOOKUP(RC[-1],DATABASE!R2C1:R65536C19,6,FALSE))"
but it doesnt work as the quotes in the middle of the if statement to return a blank cell cause an error. How can I get a blank cell if the ISNA is true ?
THANKS