LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP Formula Florida User Excel Discussion (Misc queries) 1 March 20th 06 03:00 PM
VLOOKUP result is not showing up - only the formula Linda Excel Worksheet Functions 10 December 21st 05 06:37 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
What can I add to a vlookup formula to give me a 0 not #n/a Casper Excel Worksheet Functions 4 July 5th 05 05:32 AM
IF & VLOOKUP FORMULA taxmom Excel Worksheet Functions 3 March 2nd 05 03:35 PM


All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"