Forum Discussion
Returning multiple results in one cell
The Excel file shows cities and what county they are in. Instead of it being seperated, I would like all the cities in one county such as
"West Palm Beach, Riviera Beach" in one cell and Palm Beach County as their county instead of them being separated.
Can you please explain the formula used so that I can expand the concept to include zip codes as well if possible ? Thank you.
"West Palm Beach, Riviera Beach" in one cell and Palm Beach County as their county instead of them being separated.
Can you please explain the formula used so that I can expand the concept to include zip codes as well if possible ? Thank you.
2 Replies
Hi 00264657,
Do you need the output for Country as it is there for Zip codes for "West Palm Beach, FL" ?
I am referring cell D5011 as output for Zip codes.
Regards,
DILIPandey
Dilip, i guess for County, not Country; and that's continuation of this https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Matching-Zip-Codes-to-City/m-p/74093#M749 task
