| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Function returning range
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a range using IF | Excel Worksheet Functions | |||
| OFFSET function in named range returning wrong # of rows | Excel Worksheet Functions | |||
| Returning value from a range of data | Excel Discussion (Misc queries) | |||
| Returning a range | Excel Discussion (Misc queries) | |||
| Returning a value for a number in a range | Excel Discussion (Misc queries) | |||
Threaded Mode
