Need a formula to match and pull data from a separate sheet.

[nwebbs10]

I am working through something that would require me to match and pull data from another sheet. Essentially i need to ID numbers to match, and if they do, then I need the owner's name to pull and populate.

In the example I provided three sheets. The first one is the main sheet that needs the formula for the owner's name. The second sheet is the reference sheet I want to pull from. And the last is what I want it to end up like.

Basically, if the owner ID number on the "main" sheet, is associated with a name on the "reference" sheet, then I want it pulled to the "main" sheet.

[Phuocam]

Try this in A2:

=VLOOKUP(C2,Reference!$A$2:$B$7,2,0)

[nwebbs10]

Could you explain the formula and how you put it together? So I can transfer it to another worksheet that's laid out differently.

Appreciate the help!

[AliGW]

The syntax is explained here: https://support.microsoft.com/en-us/...8-93a18ad188a1

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[AliGW]

Continue here, please: https://www.excelforum.com/excel-for...ame-sheet.html

DON'T open duplicate threads in future.