Use a cell content to filter data

[taleb]

Hi,
I am new to the Excel query scene but I already love it. However i am having a problem that I know is very easily solved. I am generating a query from a table. I want this table to be filtered on Column2 based on a value in a cell in the sheet. I tried filtering on any value and then replacing that value with a name range that I defined but it is returning 0 values where i know that there are multiple rows. I know that I can use a parameter as filter value but I couldn't find anywhere how to define this parameter referencing a cell value.

Your help will be greatly appreciated.

 

[SteveO59L]

have a look at advanced filter

 

[taleb]

have a look at advanced filter

Hi Steve,
Thank you for the quick reply. I have looked at that and it does not address my problem. In any case I found a solution on this link:
https://www.howtoexcel.org/power-query/how-to-parameterize-your-power-query/

How do I flag this post as solved?