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?