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
- Apr 13 Sun 2008 20:43
Matching two lists.
close
全站熱搜
留言列表
發表留言
留言列表

