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