Hi,
I'd like to return the name of the column based on a user providing an entry.
Here is an example:
T1 T2 T3
a d g
b e h
c f i
If the database contains the letter 'e' i should be able to reference T2, i then T3 and so forth.
I tried to use match/ index but i am probably doing this wrong as match doesnt appear to work on more than one column or row.
Many thanks in advance!!!
I'd like to return the name of the column based on a user providing an entry.
Here is an example:
T1 T2 T3
a d g
b e h
c f i
If the database contains the letter 'e' i should be able to reference T2, i then T3 and so forth.
I tried to use match/ index but i am probably doing this wrong as match doesnt appear to work on more than one column or row.
Many thanks in advance!!!