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:
gt; lets say list # 1 has the data of:
gt; Column 1 Row 1- 1
gt; Column 1 Row 2- 3
gt; Column 1 Row 3- 2
gt; Column 1 Row 4- 4
gt;
gt; List # 2 has the data of
gt; Column 1 Row 1- 1
gt; Column 1 Row 2- 3
gt; Column 1 Row 3- 2
gt; Column 1 Row 4- 4
gt; List #1 only has 1 column, List 2 has several. I need the data in
gt; #2's other column's and match them up with List 1 properly.
Take a look at VLOOKUP
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:
gt; lets say list # 1 has the data of:
gt; Column 1 Row 1- 1
gt; Column 1 Row 2- 3
gt; Column 1 Row 3- 2
gt; Column 1 Row 4- 4
gt;
gt; List # 2 has the data of
gt; Column 1 Row 1- 1
gt; Column 1 Row 2- 3
gt; Column 1 Row 3- 2
gt; Column 1 Row 4- 4
gt; List #1 only has 1 column, List 2 has several. I need the data in
gt; #2's other column's and match them up with List 1 properly.
Take a look at VLOOKUP
文章標籤
全站熱搜
