exact match using lookupvalue

[mellyVK]

hi all...

i am trying to do an exact match, but is wrong, how can i change my formula, so that it will show

if membercode = "11", it will show "affiliated" instead of "VIP"?

 

Thank you so much.

[Ashish_Mathur · Accepted solution]

Hi,

Set up a relationship from the Membercode column of Table1 to the Membercode column of Table2 (No Membercodes should repeat in Table2) and write the following calculated column formula in Table1

=RELATED(Table2[MemberType])

Hope this helps.