Forum Discussion
Solved
Lookup data from another table when text exists
Afternoon, I'm trying to work out how I can look up a value from Table A if the text in a column of Table B contains text in a different column in Table A. To give an example of the data: ...
Try removing the each between "NormalisedRoomType" and (rowB) in the Advanced Editor.
Even easier to use
= Table.AddColumn(#"Table A", "Lookups", each Table.FindText(#Table B", [TextToSearch]), type text)
--Nate
That's a neat function but I don't quite follow how it works here since PhilMeach wants to add a column to TableB, not TableA.
Thank you for heloping with this. However, I'm getting an error saying
"Expression.Error: A cyclic reference was encountered during evaluation."
I'm struggling to work out in your answer where the TextToSearch looks up in the RoomType column?
