In Sheet1 I have the following table:

A1: Product ID B1: Description
A2: 1101 B2: Eggs
A3: 4367 B3: Oranges
A4: 5433 B4: Cereals
A5: 7789 B5: Rags

In sheet 2, cells in column A will contain a drop-down list where the user can choose a product. However, the list items should look like this:

1101 (Eggs)
4367 (Oranges)
5433 (Cereals)
7789 (Rags)

Is this possible with just an Excel formula or do I need a macro? I used to make drop-down lists by giving names to ranges but that only works when my list items need info only from a single column.