Need help to modify the given formula.

Mindfull

Hi,

I and trying to write following formula where first it is checking the row ID and then matching content in the other column in the same row and returning the incremental value, but it is throwing #INCORRECT ARGUMENT SET error.

=IF({WorkOrder#} >= 1, INDEX("TD"), MATCH(({WorkOrder#} >= 1), {WorkOrder#}), 0)

Prajna

Genevieve P.

Hi @Prajna Jain

I answered your other post that had a similar question (see here). Is this the same formula? Did either of my suggestions work?

With cross-sheet formulas you won't be able to use an IF statement directly like this. You most likely will want to use an INDEX(COLLECT if you have 2 criteria to search for, like so:

=INDEX(COLLECT({range to pull from}, {first criteria range}, first criteria, {second criteria range}, second criteria), 1)

Does that make sense? Let me know if you need further direction on either post.

Cheers,

Genevieve