How to remove VLOOKUP function in Excel and retain the cell value-CodePudding

CodePudding

Home > Back-end > How to remove VLOOKUP function in Excel and retain the cell value

How to remove VLOOKUP function in Excel and retain the cell value

Time：07-28

I am using Pandas to load data from an Excel file. However, the data is lookup from another Excel file.

Is it possible to retain the cell value and remove the VLOOKUP function?

I am using:

Excel (Microsoft 365)
Windows 10

Thanks!

CodePudding user response：

Yes, I would just select the cells then copy : paste.special values and that will leave you the result of each vlookup. Do this for the row, column or cell as needed.

Page link：https//www.codepudding.com/Backend/491347.html

Prev:How to save inserted pictures in excel using VBA?

Next:Updating a column with another column's values in python but only NaN values

Tags：

excel

vlookup

Links：
CodePudding