I have two sets of data from two years as below which needed to be sorted by product and row. Eg. I need A2 and its product sales on the same row for both years.I have had a look at the the solution here but don’t know how to adjust it.

```
2012 2011
Product Sales Product Sales
A1 5 A1 3
A2 7 A4 5
A3 2 A6 3
A4 5 A7 2
A5 3 A9 4
A6 4 A10 5
A7 3
A8 4
A9 5
A10 6
```

This is the desired result which has the same product on each row for both years.

```
2012 2011
Product Sales Product Sales
A1 5 A1 3
A2 7
A3 2
A4 5 A4 5
A5 3
A6 4 A6 3
A7 3 A7 2
A8 4
A9 5 A9 4
A10 6 A10 5
```

My actual database has over 800 rows over 8 years so performing this task manually is too time consuming. Is there any efficient way of doing this?

Help is much appreciated.

`vlookup`

will do exactly this – Raystafarian Jul 16 '13 at 14:15