VLOOKUP with Multiple Criteria or should use INDEX or COLLECT?
I'm trying to do a multiple criteria look up and I'm not sure I'm going about it with the correct formula.
I have a Project ID referenced on a project profile, then the formula needs to find that project and display the data, easy with a vlookup. Here's where it gets fun, I need it to look at the next unique time entry (zap ID) and then display that data.
What formula do I use to look up the one ID match it to the next, then look up a range if ID's and then display just that data going forward?
Help Article Resources
Check out the Formula Handbook template!