Hi,
Just wondering if there is a better way to write this?
=IF(Weekend!P7="Beauchamp, Suzanne",Weekend!R7,IF(Weekend!P8="Beauchamp, Suzanne",Weekend!R8,IF(Weekend!P9="Beauchamp, Suzanne",Weekend!R9,IF(Weekend!P10="Beauchamp, Suzanne",Weekend!R10,IF(Weekend!P11="Beauchamp, Suzanne",Weekend!R11,IF(Weekend!P12="Beauchamp, Suzanne",Weekend!R12,IF(Weekend!P14="Beauchamp, Suzanne",Weekend!R14,IF(Weekend!P15="Beauchamp, Suzanne",Weekend!R15,0))))))))
regards,
Bookmarks