Question on Cross Sheet Formula

Steve Gaertner

Hi,

I am trying to write a cross sheet formula that pulls a list of tests for a manufactured item for a specific project and keep running either into an Argument error or UNPARSABLE error:

I have tried the following iterations of the formula:

=INDEX(COLLECT({Individual testing assignments Range 1},{Individual testing assignments Range 2} HAS({Batch Summary sheet Range 2}, {Individual testing assignments Range 2})))

The intent of the formula is to pull all of the testing requirements: {Individual testing assignments Range 1} for the manufactured items called out in {Batch Summary sheet Range 2}.

Where {Individual testing assignments Range 2} and {Batch Summary sheet Range 2} are matching columns.

Any help would be greatly appreciated!

Will Jeffords

Hi @Steve Gaertner , is it possible that you are just missing the comma that should be between "…Range 2}, HAS…" in your formula above? I didn't test, but I know that formula won't work as pasted above :)

Let me know!

Will

Steve Gaertner

Thanks for check, that fix returned an incorrect argument set error.