In many cases, a noun can be made plural by adding an “s”.
However, many nouns have an irregular plural form, and the main challenge is to handle these exceptions.
In the example shown, we do this with theVLOOKUP function:
wherewordtableis thenamed rangeF5:G11.
Obviously, this only works when the table contains an entry for a given word.
The idea is that words with an irregular plural form need to have an entry in the table.
At this point in the formula, we know the word should be plural.
When making a word plural, check a custom table first to see if there is an irregular form.
If there is an irregular form, use it.
If an entry is not found, simply add an “s”.
This is a limitation of the formula.
More than one condition can be tested by nesting IF functions.
VLOOKUP supports approximate and exact matching…
