Excel look up formula

Hi Experts,

Please see the attached sample spreadsheet.  I need a formula on sheet1 column D that will look up values in sheet2 column C- highlighted in yellow.

The spreadsheet has thousands of records so that is why I'm asking for help to make this task easier.

Thanks,
David
test.xlsx
dddwAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shark_Commented:
=VLOOKUP(Sheet1!A2,Sheet2!A1:C11,3)

is easier if you sort both sheets by the first column. you need to use a better identifier than just the fist name because you can get duplicates and the result will be the first name it founds.

i uploaded your files back with the formula working
test.xlsx
0
dddwAuthor Commented:
I have some limitations with the data such as not being able to re-sort it.  Is there away to use the VLOOKUP based on the first and last name?
0
Shark_Commented:
I think no, it just looks an specific value in  a mark table. you will have to create an other field adding the first name and last name in both sheets. but if you are not able to sort then I don't think you will be able to add a column. can you copy and paste the data in to an other excel book that is not restricted?
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

dddwAuthor Commented:
I'll give the VLOOKUP a try.  It may work.  There is a unique identifier that could be used instead of the name.  I'll let you know how it goes.
0
Ejgil HedegaardCommented:
Use this formula in D2 to lookup first and last name, copy down.
=INDEX(Sheet2!$C$2:$C$15,MATCH(A2&B2,Sheet2!$A$2:$A$15&Sheet2!$B$2:$B$15,0),1)
The formula must be array entered Ctrl+Shift+Enter.
Excel will enclose the formula in {} to show that it is an array formula.
Expand the ranges to what you need, don't use the entire columns on array formulas.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dddwAuthor Commented:
That works very well.  I'll give that a try on the actual data.
0
dddwAuthor Commented:
I ended up using this formula for the finalize spreadsheet with some modifications to the columns it looked at.

Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Spreadsheets

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.