I have a spreadsheet that uses a VLOOKUP referencing values in a different spreadsheet that i run a script on. Every time I run the script I get and error and #N/A for the VLOOKUP VALUE. If i click in the cells of that column, a window pop-up "Update Values: *filename*", then i click the file name again in explorer and the values populate.
i have repeated this over and over, checked the file being referenced to make sure everything matches and no matter what, it will not populate the values automatically, i have to select the file to reference.
anyone else encounter this?
i have repeated this over and over, checked the file being referenced to make sure everything matches and no matter what, it will not populate the values automatically, i have to select the file to reference.
anyone else encounter this?
