Use a dynamic range

http://www.contextures.com/xlNames01.html#Dynamic

--
__________________________________
HTH

Bob

"vardhan" wrote in message
...
I want to apply vlookup formula to Range of cells, but data may not be
static.
Help me to how to approach that...