Hello Community,
I am trying to match a selected cell to a reference of multiple columns. For my example, I want to choose a state and I want it to return which category it comes from. Each category has multiple unique states. Ex. I search for CA within whole time, I want it to return me the column name..Any feedback is appreciated.
<tbody>
</tbody>
I am trying to match a selected cell to a reference of multiple columns. For my example, I want to choose a state and I want it to return which category it comes from. Each category has multiple unique states. Ex. I search for CA within whole time, I want it to return me the column name..Any feedback is appreciated.
SW | MW | CS | SE | WS | NW | FL | NE | OTH |
AR | IA | IN | AL | AZ | ID | FL | DC | CT |
LA | IL | KY | GA | CA | OR | DE | MA | |
OK | KS | MI | MS | CO | WA | MD | ME | |
<tbody>
</tbody>