Forum Discussion
Solved
Power Query M: IF with VLOOKUP
I need a Power Query M formula version for creating a "column D" that does a VLOOKUP from TableB on colA but if it doesn't exist, then just pull col C from the original TableA. TableA and TableB ...
Hi nimblecat.
Is this the kind of thing you're looking for?
=Table.AddColumn(TableA,"col D",each TableB{[#"col A"=[col A]]}?[col B]? ??[col C])
the values must be unique in col A of TableB .