Forum Discussion
Solved
If column has a word within it pull the name in another column
Hi there, I have the below in a ss in columns A,B,C respectively. In another tab I want to have the column heading be a city. ie. Windsor. and I want to pull the first and last names of anyone who s...
The file you sent is my first suggestion where all data must be entered. Attached is the file with the changed M code which accepts rows without a city. I changed the name of the file from "If column has a word within it pull the name in another column" to "CHANGED If column has a word within it pull the name in another column" for easier identification.
In A2 on the second sheet:
=FILTER('People Sheet'!$A$2:$A$200&" "&'People Sheet'!$B$2:$B$200, ISNUMBER(SEARCH(A1, 'People Sheet'!$C$2:$C$200)), "")
Replace People Sheet with the real name of the first sheet, and adjust the ranges as needed.
Then fill to the right.