| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a range using IF
Does anyone know if it is possible to use a formular that would return a
selected range (from a different worksheet), based on the content of a given cell? I want to use the first worksheet as a form with the second worksheet containing dropdrown lists and ranges. The situation I want to create is if A1=AMH, the B1:B6 would be filled by a named range in the second worksheet. is this possible? Alan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number range returning a text value | New Users to Excel | |||
| looking for another same value cell in a range and returning a coresponding value | 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
