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