Hey,
(1)How do you stop error messages and return a blank when an error is found on a lookup.
(2) How does it work if you you also have to trim the lookup value and table array and also deal with complication such as acell treating as text and another a value etc. What formula do you use.
(3) What do the various error messages mean i.e 0 etc?
Want to make logical sense of these error messages once and for all as they may add value.
Thankyou,
Bookmarks