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 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!!
Hi nimblecat.
Is this the kind of thing you're looking for?
2 Replies
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 .
