chongsm2867
New Member
- Joined
- Apr 8, 2015
- Messages
- 4
Can't really tell the difference between the two. Can anyone explain in layman terms, please?
Thanks!
Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Difference between Related and RelatedTable
- Thread starter chongsm2867
- Start date
-
- Tags
- related relatedtable
scottsen
Well-known Member
- Joined
- Mar 16, 2014
- Messages
- 1,263
Basically... direction. Relationships have a direction (see Power Pivot Relationships | Power Pivot | Tiny Lizard). On the many side of the relations (on the side where you have many facts/data) you can do a lookup to the (exactly) 1 match in your lookup table... using RELATED().
If you are in the 1 side (the lookup table), you can do a "lookup" to the many side, but it will return many rows. For that you are using RELATEDTABLE().
If you are in the 1 side (the lookup table), you can do a "lookup" to the many side, but it will return many rows. For that you are using RELATEDTABLE().
Upvote
0
