South Nashua
New Member
- Joined
- Mar 4, 2017
- Messages
- 5
Hi all, first time posting. Wondering if you could help.
Okay, I have a column of with cells filled with text. Let's call that Column A.
In another column, I have more cells filled with text. Let's call that Column B.
I want to put a formula in Column C find where an adjacent specific cell in Column B shows up in Column A (if at all) and what specific cell in Column A that is.
Example:
<tbody>
</tbody>
C1 would lookup B1 and equal A1. C1 would lookup B1 and equal A3. C3 would lookup B3 and equal FALSE.
I've tried combinations of VLOOKUP and FIND and SEARCH and MATCH and INDEX, but it's beyond my abilities. Hoping you all could help.
Okay, I have a column of with cells filled with text. Let's call that Column A.
In another column, I have more cells filled with text. Let's call that Column B.
I want to put a formula in Column C find where an adjacent specific cell in Column B shows up in Column A (if at all) and what specific cell in Column A that is.
Example:
Dog | Dog |
Cat | Pig |
Pig | Blue |
<tbody>
</tbody>
C1 would lookup B1 and equal A1. C1 would lookup B1 and equal A3. C3 would lookup B3 and equal FALSE.
I've tried combinations of VLOOKUP and FIND and SEARCH and MATCH and INDEX, but it's beyond my abilities. Hoping you all could help.