Forum Discussion

bradleyi's avatar
bradleyi
New Member
7 years ago

Filter Power Query to a Value on a different Sheet

Hi There

 

I want filter my data based on a value on a different sheet.  I basically want to bring one row back only, and it should have the same Key field based on the key on a different sheet.

 

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([CostCode] = "1194B"))

 

The above line should not be hard coded.  I want the CostCode to refer to CELL A7 on Sheet1 for example

 

please help

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    First of all, it's Best Practice to import all the tables you need into PQ. So, no sheet, but a table needs to exist in PQ. Secondly, if you want to manipulate 2 tables at the same time, it would be good to know on which field(s) you want to join them...

    For the time being, I don't think you've explained the problem well enough to give you any definite answer.

    Best
    Darek