Quote:
Originally Posted by oscarlimerick
This all works but I don't understand why it's necessary to have the iferrror in there, what does this do? Can I get the reuslts i want just using vlookup? How would I do this? Thanks
|
In case VLOOKUP for some reason don't find the searched record, it returns an error, and IFERROR handles such cases. It will be especially useful when you have calculated controls on your form - in case a source for such calculations returns an error, the calculation itself returns an error too.
You can of-course simply ignore this, but taking care of such cases, however small the probability of them will be, is simply a good programming style.