You will need to use an extra 2 columns
e.g. in column F concatenate your employee id and 47, if employee id in column A the formula would be =A1&47
In column G concatenate your employee id and the value in column E.
e.g. if employee id is in column A then the formula would be =A1&E1.
We can now use a Vlookup to check if the employee id and 47 in say Cell f12 is listed already in Cells G1 to G11.
I don't know what formula you have in column E, but amend it to start with a Vlookup which will look for the "Employee Id & 47" in the second of the new columns.
paste this formula into cell E12, after you have completed columns F and G,
IF(ISERROR(VLOOKUP(F13,G$1:G12,1,FALSE)),"ENTER YOUR FORMULA TO SHOW 47 HERE","ZERO")
I don't know if I have explained this clearly enough but I hope it helps.
Like this thread? Share it with others