Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP()
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 -- Wales - the land of fire breathing dragons and rugby playing wizards. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP()
=IF(ISNA(VLOOKUP(E15,customers!$A$1:$B$300,2,0))," yourmessage here"
-- Don Guillett Microsoft MVP Excel SalesAid Software "Finance Guru" wrote in message ... 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 -- Wales - the land of fire breathing dragons and rugby playing wizards. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP()
=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" wrote: 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 -- Wales - the land of fire breathing dragons and rugby playing wizards. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP()
Many thanks Teethless mama. Much appreciated
-- Wales - the land of fire breathing dragons and rugby palaying wizards. "Teethless mama" wrote: =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" wrote: 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 -- Wales - the land of fire breathing dragons and rugby playing wizards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |