Use vlookup function. Follow the link below to see how.
Cell protection only kicks in when you protect the entire sheet. So for the cell to be protected, then the sheet has to be protected.
we can use the option copy and then past special value.
To copy it to another workbook, you can right click on the Sheet Tab and pick the Move or Copy option. To copy it into the same workbook. Click on the sheet tab and then press Ctrl and drag the sheet tab to copy it.
Right-click on the last tab and insert another tab to create a new blank sheet. If you like, you can right-click and copy the current sheet to create a copy at another tab.
Open both documents. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the other document.
Right-click and select paste formula
Open both documents. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the other document. If there is a pivot table in the sheet it will be copied into the new workbook.
You cannot copy data from one cell to another using a formula. A formula can only affect the current cell. What you can do is make the cell equal to the value in the cell with the formula. In that case the formula can be set to a cell in another workbook. So if you are in Book2 and want to make a cell on that the same value as a cell with a formula on Book 1, then you can do it like this, where the workbook is in square brackets, followed by the sheet name and an exclamation mark and the cell. =[Book1]Sheet1!$C$9 The other thing you could do is create a Macro to do it for you. Draw a button or a graphic onto your sheet. Right click on it and choose Assign Macro and Record. Then select the cell you want to copy from. Do a copy. Select the other workbook. Do a paste into the cell you want. Click on the Stop recording button. You will now have a macro that will copy from one workbook to another.
It contains relative cell references.
Use the Paste Special facility. From there you can then choose to paste the values, rather than the formulas.