Wanting to search the house district column for a specific district number and return the county name. The formula below works, but returns the county name (Bibb) for 140 and/or 40 instead of for just the district 140 that is being searched for. How can I get it to just pull it for 140 and not 40 or 0, etc? Thank you.
=IF(ISNUMBER(SEARCH($O$2&",",","&D13&",")),A13,0)
<tbody>
</tbody><colgroup><col><col span="3"><col><col span="4"></colgroup>
=IF(ISNUMBER(SEARCH($O$2&",",","&D13&",")),A13,0)
County Name | House Districts | District | 140 | ||
Appling | 156, 178 | 0 | 0 | ||
Atkinson | 176 | 0 | 0 | ||
Bacon | 169 | 0 | 0 | ||
Baker | 154 | 0 | 0 | ||
Baldwin | 145 | 0 | 0 | ||
Banks | 28 | 0 | 0 | ||
Barrow | 114, 116, 117 | 0 | 0 | ||
Bartow | 14, 15, 16 | 0 | 0 | ||
Ben Hill | 155 | 0 | 0 | ||
Berrien | 170 | 0 | 0 | ||
Bibb | 140, 141, 142, | Bibb | 0 |
<tbody>
</tbody><colgroup><col><col span="3"><col><col span="4"></colgroup>