Fuzzyfazzy
New Member
- Joined
- Jan 4, 2018
- Messages
- 9
Hi All,
I have a strange problem where I would like to search for a value, such as "K" in a Column and return the value of the cell below it.
i.e.
Column would contain the following data:
A
K
T
J
E
K
A
So in another column, the values returned would be T and A and so on...
Hoping someone can help as I have tried the INDEX method but it only seems to find the first "K" and I cannot seem to get it to loop on and get the next value.
Thanks in advance.
I have a strange problem where I would like to search for a value, such as "K" in a Column and return the value of the cell below it.
i.e.
Column would contain the following data:
A
K
T
J
E
K
A
So in another column, the values returned would be T and A and so on...
Hoping someone can help as I have tried the INDEX method but it only seems to find the first "K" and I cannot seem to get it to loop on and get the next value.
Thanks in advance.