Area display help

[mustbezim]

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?

 

[Squeaky]

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