How to fetch matching records where columns matches in two separate excels?

actually i have two excels where one is static and other is dynac where need to fetch values matching on 3 values from static .
select * from static where colum1=(select columns 1 from dynamic) and colum2=(select columns 2 from dynamic) and column3 = (select columns 3 from dynamic).

used inmemory lookup doesn’t working as my expectation.

Thanks,