Forum Discussion
Pricey79
Helper V
Helper VHelp with Lookup Please - Multiple values error
Hello everyone, I was hoping someone could help please I have 2 tables, they both have a title column and a name column. I would like to put an additional column in one of the tables that checks...
amitchandak
Super User
Super UserPricey79 , Seem like there is more than one record for title try like
maxx(table2, Table1[Name] = table2[Name]), Table2[Title])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Pricey79Helper V
Helper Vamitchandak Thank you for taking the time to reply
Sorry for aniotehr question but....where would I put the MAX? After the lookup?
Thank you
- Pricey79
amitchandak Hi Amit, would you know the answer to this please?