I using Excel file to store and linking testing data (TestSets, TestCases,....). But I got problem with VLOOKUP()
I have 3 file Excel.
home/main/Testing/TestingFile_1.xlsx
home/main/Testing/TestingFile_2.xlsx
home/main/Testing/TestingFile_3.xlsx
In the TestingFile_2.xlsx, I using VLOOKUP to get a data from File1:
=VLOOKUP("TESTING_001",'TestingFile_1.xlsx'#$TestCase.$A$6:$E$500,3,0)
In the first time. when I pressed Enter button, the data is correct and Input line is:
=VLOOKUP("TESTING_001",''file:///home/username/main/Testing/TestingFile_1.xlsx'#$TestCase.$A$6:$E$500,3,0)
Then when I coppy to other location, it changed to:
=VLOOKUP("TESTING_001",[33]testcase!$a$6:$E$500,3,0)
Does anyone has issue it before?