Try naming the table using a dynamic range formula.
Then refer to that range in the VLOOKUP function.
Dave
> Date: Mon, 15 Feb 2010 21:36:52 -0800
> Subject: $$Excel-Macros$$ vlookup reference automatic update
> From: pinankchh...@gmail.com
> To: excel-macros@googlegroups.com
I have customer record file in My Main pc. & backup in another pc. To
update my old data I’m using vlookup function it’s working but problem
is there when any new name will be come I have to type the name
manually and its not possible for me to find a new record and than
update coz data is more tha
