My current VLOOKUP reads as follows:
=IFERROR(VLOOKUP($A8,'Lot Data'!$A$3:$N$149,5,FALSE)," ")
In the example above, my form and the worksheet 'Lot Data' are in the same workbook.
I want to change the reference from 'Lot Data' in the formula above to refer to a worksheet 'Current' in a different workbook on OneDrive at the path below:
https://onedrive.live.com/edit.aspx?...!111&app=Excel
Is this possible? If so, what is the syntax?
Bookmarks