excel - How to reference a row in a different sheet to compute sums -

excel - How to reference a row in a different sheet to compute sums -

the sheet want reference generated separately , cannot modified. contains names of people , respective numbers. sheet called 'finish'. in separate modifiable sheet called 'tracker' reference 'finish', find person , utilize row value compute multiple columns of data.

i have tried =match('finish'!"*name*",$a1:$a100,0) code doesn't work. going utilize match value in indirect function.

in order homecoming row number of (first) appearance of *name* in column in sheet finish should write formula like:

=match("*name*", finish!a:a, 0)

in order sum values in row found match function, column b column e, need utilize formula like:

=sum(indirect("finish!b" & match("*name*", finish!a:a, 0) & ":e" & match("*name*", finish!a:a, 0)))

excel