E
Eric
Does anyone have any suggestions on how to determine the text under table?
For example,
On row 1, Apple, Susan, John
On row 2, 8, 2, 3
On row 3, 11, 7, 4
and the numbers under row 2 and 3 will not be duplicated.
In cell D2, the given text is 3, I would like to return the text John into
cell D1, because under column C, there is 3 value in cell C2, and the text
"John" is also under column C in cell C1.
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric
For example,
On row 1, Apple, Susan, John
On row 2, 8, 2, 3
On row 3, 11, 7, 4
and the numbers under row 2 and 3 will not be duplicated.
In cell D2, the given text is 3, I would like to return the text John into
cell D1, because under column C, there is 3 value in cell C2, and the text
"John" is also under column C in cell C1.
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric