Hey !
I think im struggling with the impossible here. What I need to do, is to manage a relationship with two databases in which I want to see if a particular value of DB1 exists anywhere in DB2
for example.
DB1
A
B
C
D
E
DB2
A,B,C
A,E
A
and then ideally i would have in DB1
A 1
B 1
C 1
D 0 (missed out, because it doesnt appear anywhere)
E 1
In excel I solved the prblem by index/match + ** wildcards. Is it feasible in powerpivot ?
Jakub
I think im struggling with the impossible here. What I need to do, is to manage a relationship with two databases in which I want to see if a particular value of DB1 exists anywhere in DB2
for example.
DB1
A
B
C
D
E
DB2
A,B,C
A,E
A
and then ideally i would have in DB1
A 1
B 1
C 1
D 0 (missed out, because it doesnt appear anywhere)
E 1
In excel I solved the prblem by index/match + ** wildcards. Is it feasible in powerpivot ?
Jakub