Matching two lists.

lets say list # 1 has the data of:
Column 1 Row 1- 1
Column 1 Row 2- 3
Column 1 Row 3- 2
Column 1 Row 4- 4

List # 2 has the data of
Column 1 Row 1- 1
Column 1 Row 2- 3
Column 1 Row 3- 2
Column 1 Row 4- 4
List #1 only has 1 column, List 2 has several. I need the data in #2's other
column's and match them up with List 1 properly.

Jwhite wrote:
> lets say list # 1 has the data of:
> Column 1 Row 1- 1
> Column 1 Row 2- 3
> Column 1 Row 3- 2
> Column 1 Row 4- 4
>
> List # 2 has the data of
> Column 1 Row 1- 1
> Column 1 Row 2- 3
> Column 1 Row 3- 2
> Column 1 Row 4- 4
> List #1 only has 1 column, List 2 has several. I need the data in
> #2's other column's and match them up with List 1 properly.

Take a look at VLOOKUP