I have a table with names on the top and numbers down the side
A B C D
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