close

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()