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: 6
Default how do a create a lookup using first and last name

Hello,

I have two worksheets that I am trying to create a lookup for. They both
have id #'s columns that should be the same so I tried to do a vlookup only
to discover they are not the same. The only colomns on both sheets that are
the same are first and last name. I need them both becasue some many people
have the same last name but different first names and so forth. So what I am
trying to do is take joe shmo in sheet 1 and return the data for joe shmo
that resides in sheet 2. I cant for the life of me figure out how to do this.
Does anyone have any ideas?? Thanks so much.

Teri
 
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
How to create a macro to help with lookup. Jman Excel Worksheet Functions 3 May 30th 07 05:55 AM
Does anyone know how to create a lookup that will do this? Mascot Excel Worksheet Functions 3 July 26th 06 01:54 PM
Does anyone know how to create a lookup that will do this? Mascot Excel Discussion (Misc queries) 2 July 25th 06 08:51 PM
Create Lookup Table Matt Excel Worksheet Functions 3 February 28th 06 04:02 PM
how do i create a lookup RaPiDfIrE Excel Discussion (Misc queries) 1 May 10th 05 08:31 PM


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