Verify spelling in a vlookup formula
I have a vlookup table to automatically input the population of a county when
I type in the county name. I am looking for a formula that will allow me to
crosscheck the spelling.
My vlookup table is in Column A and contains the name of the counties in
alphabetical order. Column B contains the population for each county.
Due to some fairly odd county names, I am concerned that the input will be
typed incorrectly. Therefore, I am looking for a formula to reference the
typed spelling against the accurate spelling in Column A. I would like the
cell calculation to respond, yes or no, true or false...whatever. I would
need this formula for each typed county.
I hope that is clear enough. If not, please ask.
Thanks!
Chersie
|