If #n/a

[JonesZoid]

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

[dilipandey]

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>

[dogberry]

Hi

ad iferrorr(your formula),"Missing")

The word missing will turn up every time you have an error


Chris

[rcm]

Dear JonesZoid:

If you are using Excell 2007 or beyond you can use

[code]
Iferror(vlookup(..),"Error message")
[code]

[dilipandey]

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>

[Legend Rubber]

attached a sample workbook please...?
You can use something like...?

Please Login or Register  to view this content.

[Pete_UK]

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

[JonesZoid]

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

[JonesZoid]

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.

[JonesZoid]

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.