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: 2
Default How to match information in two columns?

I have received an excel spreadsheet of 120,000 tax warrants for the city I
work in (I work at a bank). I have downloaded our customer database into
excel and need to know how to search for name matches. The customer
spreadsheet contains approx. 20 characters of the customer's name (last,
first, middle initial). How would I perform a search or match? I have never
used any lookup or match functions before. I read the help files but find it
confusing and do not get the results I anticipated. Any help would be great!
 
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
Count if two columns match different criteria Curt D. Excel Worksheet Functions 5 May 14th 23 07:44 PM
How to convert a repeating row of information to fit in 3 columns dawn Excel Worksheet Functions 3 May 21st 06 08:17 PM
add information from two columns MaryDVT Excel Discussion (Misc queries) 0 September 8th 05 07:45 PM
autofill information from rows to columns without using transpose Rayce Excel Discussion (Misc queries) 1 September 4th 05 01:44 AM
Finding a match in several columns Keren Excel Worksheet Functions 3 May 26th 05 02:32 PM


All times are GMT +1. The time now is 06:43 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"