T
tempjones
Hello,
I have a workbook which contains sheets for a 4-week rota period. A
one rota period ends, people either owe (or are owed) hours.
*I would like ...* to write a user defined function that will look at
name in Sheet X!Column A, find that name on the Sheet immediately t
the left of this sheet and return the content of a cell further alon
on the same row.
I have been trying to do this with the Index and Match function i.e.
=INDEX('March 22'!$E$12:$E$142,MATCH(C45,'March 22'!$C$12:$C$142,0))
but don't want users to have to retype the sheet name for each ne
4-week period.
What do you think? Clear as mud ... or can you help?
Thanks,
Temp
I have a workbook which contains sheets for a 4-week rota period. A
one rota period ends, people either owe (or are owed) hours.
*I would like ...* to write a user defined function that will look at
name in Sheet X!Column A, find that name on the Sheet immediately t
the left of this sheet and return the content of a cell further alon
on the same row.
I have been trying to do this with the Index and Match function i.e.
=INDEX('March 22'!$E$12:$E$142,MATCH(C45,'March 22'!$C$12:$C$142,0))
but don't want users to have to retype the sheet name for each ne
4-week period.
What do you think? Clear as mud ... or can you help?
Thanks,
Temp