Matching values in a table, with larger list of numbers and names

[aferoz]

I'm working on a project where I have two sheets of data. Each sheet contains a column for sales order numbers. The second sheet has the sales order numbers and the project name. I'm trying to figure out a way to match the sales order numbers in the first sheet to those in the second and then also append the project name that corresponds with that sales order number.

I have attached an example where sheets one and two are what I have, and I'm trying to figure out a way to automatically get the table in sheet 3.example.xlsx

Any help would be much appreciated thanks.

[oeldere]

It's possible with VLookup (zie the yellow cells).

Do you have questions, just ask.

I worked with defined names =>

Excel 2007 => formula => define names

Order_Num

=Sheet2!$A$2:$B$60