Sully1440
02-05-2021, 10:24 AM
In the attached sheet, I am having trouble with a formula to list project #'s on a sheet ("Category") from a list on another sheet ("Data") according to criteria (CAT 1, CAT 2, etc.).
Any help would be appreciated. I think it's index and match but I'm struggling with this formula..... If not Index and Match, is there another way?
Thanks,
Jim
Any help would be appreciated. I think it's index and match but I'm struggling with this formula..... If not Index and Match, is there another way?
Thanks,
Jim