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 line remains in general).
The practical case is the following: if the user filters to choose 1 project in the range $A$2:$A$43, the proper currency should be displayed in cell A2400, as each project has a different currency.
I went through the forum but could not find anything that works for my case.
Thanks a lot for your help
Gemini
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 line remains in general).
The practical case is the following: if the user filters to choose 1 project in the range $A$2:$A$43, the proper currency should be displayed in cell A2400, as each project has a different currency.
I went through the forum but could not find anything that works for my case.
Thanks a lot for your help
Gemini