Hi All,
Assuming Cell :
A1 = A B C
A2 = D E F
A3 = G H I
What I need to do is find out what row the letter / word is in.
For example if I am looking for the letter "E", I need it to return that "E" is in row 2.
I have tried find / match andI cannot figure out how to do it using formulas.
i would appreciate it if anyone can give me an idea how to solve this problem, it is driving me nuts.
Thank you very much in advance for your help.
Warren
Assuming Cell :
A1 = A B C
A2 = D E F
A3 = G H I
What I need to do is find out what row the letter / word is in.
For example if I am looking for the letter "E", I need it to return that "E" is in row 2.
I have tried find / match andI cannot figure out how to do it using formulas.
i would appreciate it if anyone can give me an idea how to solve this problem, it is driving me nuts.
Thank you very much in advance for your help.
Warren