vendredi 22 octobre 2021

Google Sheets - ARRAYFORMULA combined with MATCH back-range search

https://docs.google.com/spreadsheets/d/15q3iMg2D9KQmmmYVeqz0g7qX1pK3nf_mTiAFmTEoqyo/edit?usp=sharing

I have a problem with the use of ARRAYFORMULA together with MATCH in Google Sheets:

=IF(ISERROR(MATCH(A10,A$1:A9, 0)), "Not found", "Found")

Basically I would like to do something like that:

=ARRAYFORMULA(IF(ISERROR(MATCH(A10:A,A$1:A9, 0)), "Not found", "Found"))

The problem is following part: A$1:A9 as I do not know how to limit the range of search for MATCH just to the previous records within arrayformula. I would need to search within the range lower than A10).

Is there any possibility to use something like "back range" in array formula combined with MATCH searches?

Aucun commentaire:

Enregistrer un commentaire