Need help to modify the given formula.
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
Answers

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 crosssheet 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
Help Article Resources
Categories
Check out the Formula Handbook template!