How to determine the text?


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
 
Ad

Advertisements

K

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
 
E

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
 
Ad

Advertisements

K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top