LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
James
 
Posts: n/a
Default VLOOKUP results on last names

Hi Everyone!

I'm using VLOOKUP to match last names. The problem i'm having is multiple
people with the same name. VLOOKUP returns the fist match, what are some
suggestions and ideas so that i can get a list to choose from?
Also, is there a way to do wildcard searches in excel in a VLOOKUP or does
it absolutely have to be an exact match?

any ideas?

TIA

James


 
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 not returning results Chris Kellock Excel Worksheet Functions 14 March 19th 08 08:30 AM
format cell based on results of vlookup function Edith F Excel Worksheet Functions 1 July 21st 05 07:39 PM
VLOOKUP - results do not appear in cell denvertique Excel Worksheet Functions 1 April 22nd 05 11:41 PM
How do I do a VLOOKUP from 2 ranges and add the results together? Wendy Excel Worksheet Functions 4 April 11th 05 10:38 PM
Using Vlookup to look at different names sets of data.... Sepp! Excel Worksheet Functions 1 January 31st 05 07:16 PM


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