Forum Discussion
VLOOKUP & SEARCH Functions
It would be helpful if you could provide an example of what the data look like and of what the expected result would be.
HansVogelaar Of course! I attached a file with an example that the data comes in a very unregulated format as they are "comments" and then I listed all the cities within the state and all the hospitals. I did not list all the health systems for the overarching organization but did a few to give you an idea.
I am hoping to have a formula that scans the "comment" field for any of the city names, and facilities, (I will list states so it can populate as "Outside of State") but if a city is not found it returns "" so the cell appears blank. However, if the facility is listed but the city is now, it would be great if it could return "Unknown". I hope this helps!
Thanks. In row 2 on Sheet 1, you have Beaumont as Goal 1 and Detroit as Goal 2.
Sheet2 has 9 instances of Beaumont Hospital, but none of them is in Detroit.
How does that work?
HansVogelaar Sorry I was writing examples a little fast and just added a random city example to pull from. However, I have corrected that to reflect an example from the selections.
