-
Re: Index/Match in different scenarios on same sheet
Hi Sehret! Since you're moving from one to multiple criteria, you'll want to switch to an INDEX/COLLECT formula. To find and return a result for the PM/Supervisor, use a formula like this: =INDEX(COL…1 ·