Hi,

I have two 2 excel sheet. Sheet1 contains the emp# and noofaccess.
Sheet2 contains the employee# and noofaccess ( more than 6 times).
Based on the information from sheet1, I need to update the noofaccess
(more than 6 times) column in sheet2. For example,

Sheet1:

emp# noofacess
123 6
234 3
345 7
456

Sheet2
emp# noofaccess(more than 6 times)
123 Yes
234 No
345 Yes
456 N/A
678 N/A

COuld you please advice how to do that?. I tried the following
formula.
=IF(COUNTIF(Sheet4!A1:A4,A5)0,IF(B16,"Yes")), but its not working
out.