I am trying to do a simple lookup, but if it can't find what I'm looking up it results in #N/A.
I know it's possible, but just can't think how!
Is it possible to put an IF statement with it?
I know there are functions like ISERROR/ISNA etc, but I really just don't understand when these should be used, and have even been on the helps pages, but I still don't understand them !
Thanks for your help
Helen
I know it's possible, but just can't think how!
Is it possible to put an IF statement with it?
I know there are functions like ISERROR/ISNA etc, but I really just don't understand when these should be used, and have even been on the helps pages, but I still don't understand them !
Thanks for your help
Helen