| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop macros until reach blank in adjacent column
I have two columns, A & B. Column A contains data, column B contains a
(VLOOKUP) formulae referencing column A. I want the VLOOKUP formulae to loop down column B until it reaches a blank in column A. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
loop macros until reach blank in adjacent column
A formula will not loop anywhere. It just returns a value in the cell in
which it resides. What do you want to do? HTH Otto "McKCollins" wrote in message ... I have two columns, A & B. Column A contains data, column B contains a (VLOOKUP) formulae referencing column A. I want the VLOOKUP formulae to loop down column B until it reaches a blank in column A. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum only if cells are not blank in adjacent column | Excel Worksheet Functions | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| SUM values in a column till you reach a flag in another column- Urgent | Excel Programming | |||
| Macros - How to tell if cells in a column are blank? | Excel Programming | |||
Linear Mode
