We’ve already looked at how to use VLookup to return a corresponding value from another sheet here (VLookup Basics).

Now we’re going to expand upon that and add some conditional logic to determine if a value exists in another sheet.

Our example is looking up order numbers on a separate sheet that contains all returns. By doing this we can then analyze how many orders were returned by region, product, etc.

**Steps**

- Build your VLookup
- Add Conditional Logic If(IsError())
- Deliver insights

2. staff wise how many of them left early with their assigned time (can give one minute grace) for how many days

in excel I want to know 2. staff wise how many of them left early with their assigned time (can give one minute grace) for how many days

can anyone help me out