Last Row in Formula
 

Hi everyone. I have a workbook with lots and lots of Vlookup formulas
that reference a data sheet inside a different workbook. Periodically
I update the data sheet, and therefore thenumber of rows of data
changes. Is there a way to have the Vlookups automatically know what
row to go to in the data sheet? Can the formula include a "lastrow"
criteria instead of stating an actual number? Maybe a UDF?

Last Row in Formula
 

Use dynamic ranges, http://www.contextures.com/xlNames01.html#Dynamic

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Steve" wrote in message
oups.com...
Hi everyone. I have a workbook with lots and lots of Vlookup formulas
that reference a data sheet inside a different workbook. Periodically
I update the data sheet, and therefore thenumber of rows of data
changes. Is there a way to have the Vlookups automatically know what
row to go to in the data sheet? Can the formula include a "lastrow"
criteria instead of stating an actual number? Maybe a UDF?