Vlookup - Look for a value in a filtered list

Gemini74

New Member
Joined
Jul 26, 2019
Messages
2
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
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,685
Office Version
365
Platform
Windows
Cross-posted here: https://www.excelforum.com/excel-formulas-and-functions/1284190-vlookup-look-for-a-value-in-a-filtered-list.html#post5163442

Hi Gemini and welcome to the board.

We do not forbid cross-posting but we do require that you post references to cross-posts back to this thread. We're not trying to be difficult but we do want to make sure that our members can see what else has been suggested and even spare time should have have an answer over at the other forum(s). Please keep this in mind in future.

Thanks,
Jon
 

Gemini74

New Member
Joined
Jul 26, 2019
Messages
2
Hi Jon

thanks for your answer. What do you mean by cross posting?
I know there are several topics for this question but i did not find any proper answer.

thank you
 

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,685
Office Version
365
Platform
Windows
Bu cross-posting I mean instances where you are asking the same question across multiple forums. In this instance it appears that you also asked this question on Excel Forum - the requirement is that you post links back to this thread to such instances so that our members can see what other suggestions have been offered.

Regarding your question - what filters are being applied to generate the single row result?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,425
Office Version
365
Platform
Windows
Also posted to sites other than Excel Forum.

Please supply links to all other sites where you have asked this question.
Please read this to understand about cross posting https://www.excelguru.ca/content.php?184
 

Forum statistics

Threads
1,078,243
Messages
5,339,045
Members
399,276
Latest member
BlueCheetah

Some videos you may like

This Week's Hot Topics

Top