IF Function returning range

B

Brian

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?
 
G

Gary''s Student

You have the right idea, in general. In A6, enter:

=IF($C$4="HUD",HUD!A1,"")

and then copy down/across
 
T

T. Valko

cells A6 through C106
cells A1 through C100
Click to expand...

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.
 
B

Brian

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.
 
B

Brian

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

T. Valko

I copied down and across as instructed

Ok, that means you used Gary's suggestion.
wherever there is nothing in the cell it puts a 0.
Click to expand...

And you probably want a blank cell, not a 0?
I have 15 posibilited [sic]
Click to expand...

Are each of these on its own sheet of the same name and the range is
*exactly* the same for all 15?
 
Top