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.

"Gary''s Student" wrote:

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

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

and then copy down/across

--
Gary''s Student - gsnu200805


"Brian" wrote:

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?