Hello All,
Is there a way of displaying a message - whether it be a message box or a userform, If #N/A appears in a cell from a VLOOKUP.
Just so i can inform the user - that there is no information for this criteria.
Regards
Craig
Hello All,
Is there a way of displaying a message - whether it be a message box or a userform, If #N/A appears in a cell from a VLOOKUP.
Just so i can inform the user - that there is no information for this criteria.
Regards
Craig
Hi Craig,
Yes..
You can update you formula as =iferror(<your formula>,"No information for this criteria")
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi
ad iferrorr(your formula),"Missing")
The word missing will turn up every time you have an error
Chris
Click my star if I helped Thanks
Dear JonesZoid:
If you are using Excell 2007 or beyond you can use
[code]
Iferror(vlookup(..),"Error message")
[code]
Hi Craig,
Yes..
You can update you formula as =iferror(<your formula>,"No information for this criteria")
Regards,
DILIPandey
<click on below 'star' if this helps>
attached a sample workbook please...?
You can use something like...?
Please Login or Register to view this content.
For some reason none of your replies are showing on the New Posts list, so I'm just responding to see if that gets registered.
Pete
Sorry all - been in the bath.....
Thanks for all your help - i will try them out later - just need to attend to the family duties.....Kids are hungry....
Thanks again all
Craig
All,
The Iferror works OK....but i would like a messagebox to pop up - to get the users attention.
Would i be better using a workbook_change vba macro??
Craig.
Found This - Which Works A Charm.
All i have done is changed the msgbox text for the error i require.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks