How to determine the text?

[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

 

[KC]

what should be the value of D1 if D3 is 11, is it 'Apple'?
i have a feeling that you can better format your data...

-kc

 

[Eric]

Yes, do you have any suggestions?
In cell D2, the given text is 11, the text "Apple" will be return in cell D1.
Thanks in advance for any suggestions
Eric

 

[KC]

Apple Susan John
8 2 3
11 7 4

enter the below formula in
A4
=IF(COUNTIF(A2:A3,$D$2)=1,A1,"")

B4
=IF(COUNTIF(B2:B3,$D$2)=1,B1,"")

C4
=IF(COUNTIF(C2:C3,$D$2)=1,C1,"")


the above formulas will display the respective row1 name where ever it finds
the D2 value.

now enter the below formula in D1 (which will display the required result)
=CONCATENATE(A4,B4,C4)

-kc
*Click YES if this helps