Cross Sheet VLOOKUP/Index/Match?
Hello! I have a Project List and a Capacity Planner. I would like to have the Project Name (from the Project List) be automatically added to the Capacity Planner if the Active box is checked on the Project List. I have tried with a VLOOKUP and I'm getting an incorrect argument set error message. Could someone please share the formula I should be using? Thank you!