Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Vlookup with validation | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |