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!
Bookmarks