VLOOKUP Function Break Link – This function is a way to use the “Edit Links” function which is used to break links between different Excel files. If you mainly use the VLOOKUP function, you can use this function to copy data values from an Excel file at once.
How to disconnect the VLOOKUP function
Use the disconnect function between Excel files.
Data > Edit Connection > Disconnect Connection
DATA > EDIT LINKS > BREAK
Excel file external data connection editing sequence
As shown below, there is “A file” on the left and “B file” on the right.
Use one of the VLOOKUP multi-condition functions to load the values in column C of file A into column C of file B.
VLOOKUP Multi-condition review
The VLOOKUP function used in column C of “B file” is as follows. (Please check the link above for more details.)
C2 cell formula
= VLOOKUP(A2&B2,'[A file.xlsx]sheet1′!$C$1:$D$11,2,0)
After loading the desired value with the VLOOKUP function, use “Disconnect” to copy the data value as shown below.
Once all external data connections to the relevant Excel file are completed, the “Edit Connection” function is disabled.
conclusion
We learned how to copy values by removing the connection between values imported from an external file among Excel file formulas. Simply disconnecting external data after VLOOKUP is a way to maintain accurate values and manage correct data. Excel frequently used “Shortcut keys”We recommend that you register and use it.
VLOOKUP function to load original value format while maintaining it