Filtering Range from Column A based on criteria from Column B, into a cell on another sheet. Cannot get arraytotext or filter to format correctly
I have this table of Gods from D&D and i have a list of cleric domains on another sheet
By using the Domain 1 and Domain 2 columns be the criteria I want to filter the names in the Deity column into the corresponding cell in column D
Example
If a cell in Domain 1 or Domain 2 columns shows the word "Arcana" like D3 does i want to take the word Azuth from A3 and copy it into cell D6 on the blue sheet. But if there are multiple results i need to copy all of the deity names from column a into that same cell on the blue sheet..
I tried =FILTER(Table5[Deity],Table5[[Domain 1]:[Domain 2]]=Arcana,"")
I tried =ARRAYTOTEXT(FILTER(Table5[Deity],Table5[[Domain 1]:[Domain 2]]=Arcana,""))
All i got was a value error and i cant figure out what im doing wrong here.
[link] [comments]
Want to read more?
Check out the full article on the original site