Forum Discussion
VLOOKUP returning wrong values when linked to external sources
I have been having issues with VLOOKUP returning the wrong values from an external linked workbook that is saved to Box.com. Just a little more information: I maintain a large Excel workbook that co...
=VLOOKUP($B9,[DMASTER]DMASTER!$B:Z,7,FALSE)
I recommend making this a specific range rather than referring to the entire columns. It will use less resources and help the link update faster.