VLOOKUP - Make Return Permanent

T

TeeGee

Is there a way to convert the return data from the VLOOKUP Formula to make it
permanent (rather than linking).

I am copying the data into adjacent sheets to make different reports and it
is very slow working with the VLOOKUP formula results.

Thanks for your help,

TeeGee
 
V

Vasant Nanavati

Not sure what you mean. Once you have the VLOOKUP data, perhaps you want to
Edit | Copy | Edit | Paste Special | Values. That will "fix" the values but
the formulas will be gone.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
VLOOKUP Not working 3
Need Help with a VBA subroutine 0
Indirect formula errors if file is closed 0
Referring to a cell by using another cell for the row number 6
VLookup Won't Copy down (#REF! error) 1
Using a vlookup to search multiple criteria for one result? 7
Look up one value and return multiple corresponding values 2

Top