R
ryguy7272
I have subtotals on the second page of my workbook, counting names of
persons, and a list of persons on the first page. I though, maybe, I could
use Index/Match to get the results of the counts of the persons on the second
page into a table of names on the first page, but that didn't work. I have
this function:
=INDEX(RUBY!$D$2:$D$4500,MATCH(B5,RUBY!$D$2:$D$4500,0))
This matches the names fine, but I really wanted to putt the numbers (the
counts of names) into the table of names.
Please help.
Thanks,
Ryan---
persons, and a list of persons on the first page. I though, maybe, I could
use Index/Match to get the results of the counts of the persons on the second
page into a table of names on the first page, but that didn't work. I have
this function:
=INDEX(RUBY!$D$2:$D$4500,MATCH(B5,RUBY!$D$2:$D$4500,0))
This matches the names fine, but I really wanted to putt the numbers (the
counts of names) into the table of names.
Please help.
Thanks,
Ryan---