Forum Discussion

Protocoder's avatar
Protocoder
New Member
4 years ago
Solved

2 way table comparison with 3 columns

Hello Experts, I am trying to do 2 way comparison of tables with one column in one sheet and 2 columns in another sheet.    Sheet 1: ABC123 ACD2343 Arnold Abigail  Barbara  Dian...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Protocoder 

     

    You can try the following methods.

    Column:

    Look1 = LOOKUPVALUE(Table1[Column],Table1[Column],[Column1])
    Look2 = LOOKUPVALUE(Table1[Column],Table1[Column],[Column2])

    This is the result of the matching of column 1 of Table 1 and column 2 of Table each. Does this meet your expectations? If not, please tell us what you expect the result to be?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Protocoder 

 

You can try the following methods.

Column:

Look1 = LOOKUPVALUE(Table1[Column],Table1[Column],[Column1])
Look2 = LOOKUPVALUE(Table1[Column],Table1[Column],[Column2])

This is the result of the matching of column 1 of Table 1 and column 2 of Table each. Does this meet your expectations? If not, please tell us what you expect the result to be?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.