Compare and search multiple columns, return text as answer

[ackjaf]

I'm having a total brain fart.
I have a list in A, I need to search for that value in a list D, E, F, G. The value in A is in only one of the columns. I need to return the header name of each particular column in to B.

I hope I explained this semi clearly. I think i attached a book with sample data. This list goes on for 900ish rows.
Thanks in advanced for the help!
-Josh
Book1.xlsx

[jewelsharma]

use the following formula:

Please Login or Register  to view this content.

Also, see Sheet2 on attached - Book12.xlsx
HTH!

[ackjaf]

With some tweaks I got this to work. You are beautiful.
thank you!
-J

[FDibbins]

Here is another option (a bit messy)...
=IF(ISERROR(MATCH(A2,$D$2:$D$11,0)),IF(ISERROR(MATCH(A2,$E$2:$E$11,0)),IF(ISERROR(MATCH(A2,$F$2:$F$11,0)),IF(ISERROR(MATCH(A2,$G$2:$G$11,0)),"","N"),"OR"),"R"),"O")

[samba_ravi]

=IF(COUNTIF($D$2:$G$11,A2)=0,"Not Found",SUBSTITUTE(INDEX($A$1:$G$1,SUM(INDEX(($D$2:$G$11=$A2)*COLUMN($D$2:$G$11),0))),"GROUP ",""))
Try this formula in "B2" and copy towards down

[jewelsharma]

FDibbins,
I was doing exactly that, but then I thought of using COUNTIF() instead of IFERROR(MATCH())

Cheers!