ISERROR Help

[Halifax81]

Hi,

I have the following formulae which works fine, I wish to add to it ISERROR so that anything N/A is returned as a blank space but im struggling to incoroprate it to the formula at this moment in time!! Probally quite obvious on a fresh mind

=IF(VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2)="::"," ",VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2*1))

Thanks in advance for any help

 

[j_latendre]

Try:

=IF(ISERROR(IF(VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2)="::"," ",VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2*1))),"",IF(VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2)="::"," ",VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2*1)))

Jesse

 

[Halifax81]

Try:

=IF(ISERROR(IF(VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2)="::"," ",VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2*1))),"",IF(VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2)="::"," ",VLOOKUP($C$1,'[AHT.xls]April - Week 1'!$A$3:$D$730,2*1)))

Jesse

Brilliant Thanks I always end up missing brackets out!!!!