Text in cell which then gives a specific word in other cells in the same row

[Henpest]

In cell A1 I have a word, say Apple in A1. Is it possible when this word is entered in cell A1 I can then have another word or words appear along that same row - for example, can the word "yes" or "no" appear in cells A4, A5 and A6.

Thanks in advance.

[Special-K]

in A4
=IF(A$1="Apple","Yes","No")
copy down to A5 and A6

[Henpest]

Thank you very much. That worked. Sticking with that answer, is it possible to put multiple words, say apple, banana, grape into a formula in 1 cell and have it give the answer either "yes" or "no" across that row in individual cells i.e. B1, C1, D1.

Thanks

[Henpest]

Thank you very much. That worked. Sticking with that answer, is it possible to put multiple words, say apple, banana, grape into a formula in 1 cell and have it give the answer either "yes" or "no" across that row in individual cells i.e. B1, C1, D1.

Thanks

[Tony Valko]

Post a few rows worth of data and tell us what results you expect.

Or, it may be better to post a SMALL sample file so we can see how your data is structured.

SMALL = about 20 rows worth of data

[Henpest]

Sorry, but I'm struggling to attach the file. If this explanation helps - When I type a word into a cell in Column A, i.e. Apple in cell A1 would return Yes in B1 and D1, and Banana in A2 would return yes in C2 and D2. I have particular headings in these columns and the Yes's will correspond with whichever word I type into column A when they meet the criteria of these headings. Basically, I need a formula which has multiple words and when a particular word is typed into a cell in column A, depending on what criteria is, it will select a "yes" into particular cells in these columns. Thanks for taking the time to help.

[Tony Valko]

Is this what you want:

...............Apple......Bananna......Grape
Apple........Yes........No..............No
Apple........Yes........No..............No
Grape........No.........No..............Yes
Apple........Yes........No..............No
Apple........Yes........No..............No
Bananna....No.........Yes.............No

[Henpest]

Yes! Exactly like that.

[Tony Valko]

With the column headers in B1:D1...

Enter this formula in B2:

=IF($A2=B$1,"Yes","No")

Copy across to D2 then down as needed.

[Henpest]

That works. Thanks for your help. Until the next time. Cheers.

[Tony Valko]

You're welcome. Thanks for the feedback!