LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 45
Default Lookup Exact Match

Two Sheets: "Data" and "List"

"Data" has a list of Cities in Column A.
"List" has a list of Cities in Column A and corresponding zip codes in
column B.
I am trying to lookup all the appropriate zip codes and put them to column B
in the Data sheet.

So far, I am using =LOOKUP(A1,LIST!B:B,LIST!A:A). It works, but if I have
two cities that are similar (i.e. Bellwood/Bellmont), it does not give me the
exact match. How can I get an exact match? I am pulling my hair out over
this one!
 
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
Lookup and Match with not exact numbers Jon Dow Excel Worksheet Functions 3 February 23rd 07 03:54 AM
Match - Exact - Lookup? Danny Excel Worksheet Functions 5 April 27th 06 10:04 PM
Match name not exact Samantha Excel Worksheet Functions 3 April 11th 06 01:12 PM
Lookup returns message box when an exact match is not found JFeeman Excel Worksheet Functions 3 February 11th 05 07:19 PM
Getting an exact match Roland Excel Worksheet Functions 2 January 25th 05 05:00 AM


All times are GMT +1. The time now is 06:01 AM.

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"