close

I have a table with names on the top and numbers down the side
ABCD
1
2
3
4
On sheet one I have the numbers listed for each person and a count relating
to each number eg
A has 5(1) 6(2) 7(3) 8(4)
B has 5(1) 8(2) 9(3) 13(4)
C has 5(1) 7(2) 8(3) 13(4)
D has 6(1) 7(2) 8(3) 9(4)
the counts, name and values are all in columns.
how do I populate the table using the criteria of the name/number
i tried to
=IF(AND(Sheet1!B2=Sheet2!$B$10,Sheet1!A2=Sheet2!$C $8),Sheet1!F2,FALSE) but
cant seem to get anything to work

Thanks
Chrisk

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

    software

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

    E-mail轉寄