Verified answer

Put that formula in cell a2.

I don't have Excel on the computer I'm typing from, but I think the format is something like:

=if(a1="said text", "This text", "")

do a touch diagnosis in google on the index tournament formula. It compares to workbooks and then tells you whether say "Column A" in e book a million suits "Column A" in e book 2. you would be able to additionally tell if which value to return