Power Query M: IF with VLOOKUP

[nimblecat]

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 has a many:one relationship set-up.

In excel formula this would be:

col D = IF(VLOOKUP(... ), COLUMN_IN_TABLE_A, VLOOKUP(... )

TableA: 

col A	col B	col C
A	1	apple
A	23	banana
B	3	cherry
C	4	daisy

TableB:

col A	col B
A	dd
B	cc

Wanted Final Result:

col A	col B	col C	col D
A	1	apple	dd
A	23	banana	dd
B	3	cherry	cc
C	4	daisy	daisy

THANKS!!

[wdx223_Daniel]

=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 .

[talbot · Accepted solution]

Hi nimblecat.

Is this the kind of thing you're looking for?