VLOOKUP - Make Return Permanent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Dynamic col_index_num in VLOOKUP? 5
Referring to a cell by using another cell for the row number 6
vlookup formatting problem 1
Searching the formula (not the value) for a text string 1
Store formulas in Vlookups? (another try ;) 6
VLOOKUP return cell location and hyperlink 0
SUM with nested VLOOKUPS - can i make it ignore N/As? 5

Back
Top