I am new to working in Excel and I am trying to come up with a format that will allow entries of all workers' and their hours on a main sheet, which can then be viewed under a sheet specific to them. There should only be 2 columns of data to search. One of the employee, and the next of hours worked. I have tried using a VLOOKUP formula, but I am getting #N/A or repeated data entries. I have tried reading allot of the posts here for an answer, but they are beyond this level. I know this is probably elementary, but I'm stumped. Please set me on the right track here.
Thanks in advanced.
Thanks in advanced.