Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the help. I'm trying to move the corresponding values from Table 2 Col C to a new column in Table 1 and this solution doesn't seem to work, nor does the one above. One challenge is that I cannot filter out duplicates for Table 2 Col C because all values are between 1 and 5 (so there are technically duplicates.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Could you please What the error occored in formula when you follow the suggestions mentioned in my original post?


Best regards,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    No error, but the related Table 2 Col C values are not being brought over (most are blank). I believe this is because there are many "duplicates" and ID1 needs to be matched before ID2 to find the correct value. ID1 is like a document number and ID2 is the chapter—e.g. there are many entries for a single book (and many books referenced) and all books have a chapter 1 and so on, so both IDs are needed, sequentially, to find correct value in Col C.

     

    Thanks again for the help.