Hi
At work we use a basic spreadsheet to record attendance of employees. Employee names are across the columns, two columns per employee to denote half shifts. Dates are on the rows with each date in row B. What I would like to do is link the data into a separate worksheet (I've done this bit), then look for all occurences of holidays, represented by the value 5, for each employee. Using this I want to create a table that shows the holiday dates that each employee has taken.
Is it possible to do this, I've had a look at the VLOOKUP and HLOOKUP functions but I can't see how to make these do what I want.
Thanks in advance
Bookmarks