I like to put my table on a dedicated worksheet. Then I can use the whole
column without worrying.

=vlookup(a1,sheet2!a:e,3,false)

But you could use a dynamic range name that grows/extracts with your data.

Take a look at Debra Dalgleish's site to read more about it:
http://www.contextures.com/xlNames01.html#Dynamic

Shaya M wrote:

I already have set up a Vlookup but i want to add more items to this how to i
make the range include the newly added data

--

Dave Peterson