how do a create a lookup using first and last name

T

Teric506

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
Create a chart from a table in word thats dynamic 0
Creating a Search using a combo box and then creating a report. 4
Create tool bar 2021 0
Section and Page numbering 0
We try to save msg in got the error in outlook 2021/office 365 0
Grouping Names in Mail Merge 0
Outlook Web - Sorting Calendars by Alphabetical order? 0

Top