Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

IF and LOOKUP for multiple values

Hi, I have two tables, spend table and contract table similar to the below normalised data   I have linked the two tables by Vendor ID and have a dim-date (calendar) table. This may be two issues...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thanks, that has got rid of the error, but all the responses are "no" when there definately should be some "yes"

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Can you share sample data and sample output in table format?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I can't work out how to attach an excel spreadsheet to share the data

    • smpa01's avatar
      smpa01
      Community Champion
      4 years ago

      Anonymous  please upload in 1/g drive and share the link here and mention the desired end result too.