| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
address command for a range of cells, not one cell
address comand returns value of a single cell, by giving the cekk address as
text input. Is it possible to return a range of cells, instead of one vell either by address or any other command? In the following formula: VLOOKUP($A1239;[runs_input.xls]run1!$G$4:$G$145;1;0) I want to give [runs_input.xls]run1!$G$4:$G$145 range, as an input so that I can copy run1 easily from run1 to run50. -- Rasoul Khoshravan Azar Civil Engineer Osaka, Japan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| Determine if Cell Address is within a Range | Excel Worksheet Functions | |||
| Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) | |||
| Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Threaded Mode
