0

How can you write a macros that will loop until it finds a blank cell. Then, once the first blank cell is found do a vlookup to a set of data? It will be looping on the same row.

Edited by devinem

2
Contributors
1
Reply
7
Views
2 Years
Discussion Span
Last Post by Taywin
0

Not sure what you mean by your question... If it is OpenOffice, you should take a look at VLOOKUP(). The first value would be an empty string, and the first column in table array must be the column you are looking for. i.e. VLOOKUP("", A2:C7, 2, TRUE).

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.