Vlookup

Hi,
I am using a vlookup function to retrieve values from a another
spreadsheet. However not all the values that I am searching for may be
on this spreadheet. If a value is missing then the administrator will
have to find the value elsewhere and then overtype the the vlookup
formula. This causes an issue in so far that the next time the
spreadhseet is opened the vlookup formula will be missing from one of
the cells.

Has anybody got any ideas that will allow me replace this formula
automatically when the spreadsheet is next opened?

Thanks
Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=466619

suggest a macro to run on open where you copy the equation as needed -
see the below

http://www.excelforum.com/showthread...pen+workb ook


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=466619