I have two worksheets: the main worksheet has all the employees with the
employee number in column A sorted ascending and years of service in col D.
The workbrain worksheet has employee numbers in A and my formula in G which
is:

vlookup(a2,main!a2:d1491,4)
the information is correct that is returned, but I have employees that is on
the workbrain sheet and not on the main, and it is pulling in 10.75 on these
10 cells. Is there a way to add to my formula that if it doesn't find that
emp # to bring in a 0?