Hi,
I have what I guess is an easy problem for people here. I am trying to define an array based on a formula, but I am not successful so far.
Let say that I want to write a MATCH formula, looking for a match between column A and D, but for a row which is a variable. How should I declare something like An:Dn, with n=ROW() ?
Array.xlsx
Thank you,
Guillaume
Bookmarks