Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Look at 6+ Columns, Return Related Value

Hi! I am trying to figure out a formula that looks at 6+ values in a row, references my related table and returns the matching value. The LOOKUPVALUE + RELATED function combined has gotten me results for a particular value, however I need to analyze multiple columns. Any help would be greatly appreciated!

 

Thank you!

 

M

lookup
related

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for your reply lbendlin.

    Hi Anonymous 
    Is your problem solved now? If not, can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

     

     

     

    Best Regards,

    Jayleny