hello,
i have had a problem that you solved for me earlier in the week, i had the #n/a coming up with uncalculated formula in (looked unprofessional)
i used
=IF(ISNA(INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0)),"",INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0))
to get round problem
now i have same but with #DIV/0! coming up is there a way round this one
kind regards
i have had a problem that you solved for me earlier in the week, i had the #n/a coming up with uncalculated formula in (looked unprofessional)
i used
=IF(ISNA(INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0)),"",INDEX(Supplier!$C$5:$C$505,MATCH(B6,Supplier!$A$5:$A$505,0),0))
to get round problem
now i have same but with #DIV/0! coming up is there a way round this one
kind regards