Word equals charecters in different cell

[Ipsl]

I want to format cell A5 so as to where if I put in one of several keywords into it, cell A7 puts several letters (with spaces)

example A6:Normal = A7:AA AA AA Ive got about 10 select words so just one example would be awsome! 07 excel BTW

[VBA Noob]

Not sure I follow

You mention A5 then you mention A7 then A6.

If you want to join text use

Please Login or Register  to view this content.

otherwise give a better example

VBA Noob

[Ipsl]

Im sorry I ment only A5 and A6

so like when A5= normal than A6 = AA AA AA

[VBA Noob]

A5= normal

What does this mean ??

VBA Noob

[Ipsl]

So when I put the word Normal in A5 I want A6 to say AA AA AA Im really new at this and Im beginning to see just how robust excel is.

[VBA Noob]

Still not sure I follow

Try

=IF(A5="normal","AA AA AA","")

VBA Noob

[Ipsl]

SWEET!! Thanks though if I wanted to add several more instances, would I add the statement within same parentheses?

=IF(A5="normal","AA AA AA","A5="bell","bb AA AA")

or

=IF(A5="normal","AA AA AA",""),=IF(A5="bell","bb AA AA","")

?

[VBA Noob]

I would set up a table and use VLookup

See link for more

http://www.excelforum.com/showthread.php?t=629901

VBA Noob

[Ipsl]

Sweet thats EXACTALLY what I was looking for. Dude your helping more people than you know. If you want I'll give you a copy of this program when Im done

[VBA Noob]

Your welcome

No need to send the file

VBA Noob