ExcelBanter - Matching two lists.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Matching two lists. (https://www.excelbanter.com/excel-discussion-misc-queries/77847-matching-two-lists.html)

Jwhite

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.

Paul Lautman

Matching two lists.

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

All times are GMT +1. The time now is 01:46 AM.