How to create an text based spreadsheet Closed

Question

I have access to Excel 2010 in an MS Office Suites.

What I am try to do is to create a spreadsheet where I can enter a designated code (i.e. A1, A2 etc,) into one cell, and for a set text to appear in an adjacent cell.  The designated text would need to be picked up from either somewhere on the same sheet or another.

So say I enter "A1" in one cell and desire that text in terms of "Jack and Jill" appears in an adjoining cell.  Then if I enter A2 in the cell below, I want it to show the text "The grand old duke of York".

I want to have a number of prescribed paragraphs one after the other, probably about 100.  I would select those paragraphs relevant to my needs - i.e. A1, A3, B5 etc.

Can anyone help and give me step by step instructions how I can do this?

ac3mark · Answer

Please reference the IF syntax below: 

=IF(a1="yes,"A1=YES","NOPE, IT DOESN"T WORK!")

The format for the above Statement, is as follows:
=IF(Logic_test,true,false)

You can nest IF statements, as in:
=IF(A1="yes",IF(B1="yes","THEY ARE BOTH YES!","ONLY A1 is yes"),"neither one is yes")

I hope this has helped, and you have learned a little.  Post back some code if you get stuck!

Have FUN!
 
It's kind of fun to do the impossible! -Walter Elias Disney

ac3mark · Answer

Ok, so you may have to make those paragraphs into "RANGES".  We cannot programmatically format the sheets for you!

Logic test against the RANGES!

See Below. 
 
NOTICE the window that has "select" in it!  That is a RANGE of the cells that have a value in them.  Does this make sense?

Now you can test against RANGES!
It's kind of fun to do the impossible! -Walter Elias Disney

How to create an text based spreadsheet

2 responses

Similar discussions

Subscribe To Our Newsletter!