Power Query M language- Conditional Lookup/Merge

Hello,
could you please help me write an M language expression equivalent of Excel formula:

=IF(B1="CA",VLOOKUP(A1,'Cad Pricing'!$A$1:B3,2,FALSE),"VLOOKUP(A1,US Pricing'!$A$1:$B$3,2,FALSE)")

to be used in the Power Query editor to add a column that looks up pricing in two queries Cad Pricing and US Pricing (connected to the the same file) depending on the value in another column
Thank you!

Assumptions
- the first table has columns Name and Amount and is called Table1
- the table on 'CAD Pricing' is loaded into Power Query and that query is called CADPricing
- the table on 'USD Pricing' is loaded into Power Query and that query is called USDPricing

Formula:

Please Login or Register  to view this content.

Thank you so much! I will give it a try.