Avatar of Gene Klamerus
Gene Klamerus
Flag for United States of America

asked on 

Substituting Lookup values for formulas in Excel

I need to bring over 3-4 columns of several hundred rows of data from one excel workbook to another.  I can insert the vlookup formula in the target, but is there anyway in Excel to replace formulas with values in-place or do I need to create temporary working columns with the formulas and then do a copy-n-past from that into the target somehow.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon