Hello to All...

I have 2 spreadsheets on the firts one I have this:

Names Monday Tuesday Wed

Group (1)
Carla P LOA
George P LOA P
John P LOA P

Group (2)
Carla P
Robert P LOA P
Mike P P

But then, I am using in second separate sheet with a list of all my employee organized aphabetic so that I make sure I am not missing an employee on my report by groups.
the problem is that because this employee switch from one job to another I have duplicates names on the same sheet ( example Carla)..
so when I use INDEX MATCH on my second sheet.. I does not come out the "P" of present or LOA for Carla for example,
It comes out "0" (cero) because it brings the info from the empty cell ( the job where the employee did not work on that day) ..
there is any kind of condition I can use to have this worked out or it is just impossible?
Thanks to all for any kind of info.. this will really help me lots at work.
Giannina