asked on

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

Shark_

=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

David

ASKER

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?

Shark_

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?

David

ASKER

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.

ASKER CERTIFIED SOLUTION

Ejgil Hedegaard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

David

ASKER

That works very well. I'll give that a try on the actual data.