View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chersie
 
Posts: n/a
Default 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