Prev: Font Color Conditional Formatting/Color Scaling
Next: Trouble with linset
From: mustbezim on 4 Mar 2010 13:39
I am trying to find out how to display information over multiple cells. By
this i mean i have a formula (not sure if i should use another) (=IF(A6="Wet
Navy") that when Wet Navy is written in A6 the "if" function will execute. i
also have an are with information on it (15Cx37R) that is far off to the
side. I am trying to find a formula or function somewhere to have all the
cells in the 15x37 to show in another 15x37 area when the "if" condition is
met. Does anyone have any ideas on how to accomplish this?
From: Squeaky on 4 Mar 2010 15:41
Hi mustbezim,

Not hard.

As a mini example, pull up a blank spreadsheet. We will use a6 to put "Wet
Navy" in.

In, say, f6 put in the number "1" without quotes, and drag that over and
down to make a small grid, say 4x4.

In another cell, say f12, put

=if($a$6="Wet Navy",f6,"") Make sure you use the $ AS SHOWN.

Drag this over 4 and down 4.

Type WET NAVY in A6 and the second grid should appear.

You can use this anywhere as big as you need.

Squeaky

"mustbezim" wrote:

> I am trying to find out how to display information over multiple cells. By
> this i mean i have a formula (not sure if i should use another) (=IF(A6="Wet
> Navy") that when Wet Navy is written in A6 the "if" function will execute. i
> also have an are with information on it (15Cx37R) that is far off to the
> side. I am trying to find a formula or function somewhere to have all the
> cells in the 15x37 to show in another 15x37 area when the "if" condition is
> met. Does anyone have any ideas on how to accomplish this?
 | 
Pages: 1
Prev: Font Color Conditional Formatting/Color Scaling
Next: Trouble with linset