Please help, I have a few of these to do.
I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas?
=IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured V}, {Vendor Type}, "A/V", {Meeting ID V}, [Meeting ID]@row ), 1))