Dear all,
I would like to lookup a value, in a list that can change because it is filtered thanks to the automatic filter.
Let's say that I want to look for the value contained in the cell A2400, in the range $A$2:$A$43, but the visible lines in that range can change due to filtering (Only 1...