I have been a long time viewer of this forum but just recently signed up. Based on what I have found on here I know that someone has an answer to this problem.
I have a cell in column B that contains a string of values (example 1) on one sheet in a workbook. On another sheet I have cells that contain the single values found in column B. I am trying to return the value in Column A when a match if found in Column B. I can use the Find function to determine starting position but I haven't found a way to find the row reference after finding the value in column B. Assume that the value in column B only occurs once across all rows. 'Value 1' will only be in one cell in one row.
Match value
Value 1
Value 2
Value 3
etc...
Example 1
[TABLE="width: 323"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Ref1[/TD]
[TD]Value 1, Value 2, Value 3, Value 10[/TD]
[/TR]
[TR]
[TD]Ref2[/TD]
[TD]Value 4, Value 5, Value 9, Value 15[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]
I have a cell in column B that contains a string of values (example 1) on one sheet in a workbook. On another sheet I have cells that contain the single values found in column B. I am trying to return the value in Column A when a match if found in Column B. I can use the Find function to determine starting position but I haven't found a way to find the row reference after finding the value in column B. Assume that the value in column B only occurs once across all rows. 'Value 1' will only be in one cell in one row.
Match value
Value 1
Value 2
Value 3
etc...
Example 1
[TABLE="width: 323"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Ref1[/TD]
[TD]Value 1, Value 2, Value 3, Value 10[/TD]
[/TR]
[TR]
[TD]Ref2[/TD]
[TD]Value 4, Value 5, Value 9, Value 15[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]