VLOOKUP()

[Finance Guru]

Hi All,

I am using Excel 2007.

My Question is this :-

The below function checks whether the account number entered by the user in
E15 is valid. If it is it displays,it displays the customer name in F15.

How can i amend this function to show that if an account number is not valid
( ie. not found by the lookup function) in F15 the message is displayed thus
' Account number not valid,please try again ', instead as it does now F15
remains blank until a valid account number is entered in E15.

All assistance greatfully accepted.

=IF(ISNA(VLOOKUP(E15,customers!$A$1:$B$300,2,0)),"
",VLOOKUP(E15,customers!$A$1:$B$300,2,0))

FinanceGuru

 

[Don Guillett]

=IF(ISNA(VLOOKUP(E15,customers!$A$1:$B$300,2,0)),"yourmessage here"

 

[Teethless mama]

=IF(E15="","",IF(ISNA(VLOOKUP(E15,customers!$A$1:$B$300,2,0)),"Account number
not valid, please try again",VLOOKUP(E15,customers!$A$1:$B$300,2,0)))

 

[Finance Guru]

Thank you Don - much appreciated.
Apologies for the crap spelling,it is just one of those long, hot ,sunny days

 

[Finance Guru]

Many thanks Teethless mama. Much appreciated