Thank you very much. Now I have a couple more questions. I copied down and
across as instructed and now wherever there is nothing in the cell it puts a
0. Also, if I want the "HUD" to be interchangeable, what do I do? For
example, HUD may be Tax Credit or something else. I have 15 posibilited of
what it could be and what I am wanting is, depending on which one of the 15
it is in C4, then it returns a different range of cells from a different
worksheet? Am I asking too much? Sorry, I'm not too familiar with this.

Thank you.


"T. Valko" wrote:

cells A6 through C106
cells A1 through C100

A6:C106 = 101 rows
A1:C100 = 100 rows

Select the range A6:C105 so that A6 is the active cell.

The active cell is the one in the selected range that is not "blueish".

Type this array formula:

=IF(C4="hud",HUD!A1:C100,"")

Now, instead of hitting the ENTER key hold down both the CTRL key and the
SHIFT key then hit ENTER.


--
Biff
Microsoft Excel MVP


"Brian" wrote in message
...
I'm trying to create an IF Function that returns info from a range of
cells.
This is what I have so far:

=IF(C4="HUD",HUD!A1:C100,FALSE)

If a certain cell (C4) is HUD then I want cells A6 through C106 to fill in
with info from the HUD worksheet cells A1 through C100. Not sure what I
am
doing wrong. Is the IF Function even the best function to use for this?