All,
On the attached, on "Summary" tab, I want to return the value for the corresponding name for the headings supplied (entitlement, remaining,sick)
The "Summary" tab should draw this info from the "Coleshill" or "Stratford" tab.
I know I could simply equals the cell for the relevant name but I want to be able to add new names in and use the same formula.
i.e. I want excel to look at the name on both sheets and return the relevant value for the three headings.
Hope I'm making myself clear.
Thanks.
Bookmarks