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