convert vlookup data returned to standalone text.

  • Thread starter Thread starter NHarkawat
  • Start date Start date
N

NHarkawat

Simply copy it then go to Edit>paste special>values
This will eliminate the link
 
Hello. Frank Kabel has helped me greatly with the response to the question
below. However, now I'm trying to be able to create a snapshot or convert the
returned data from the vlookup to independent text that is no longer linked
back to the source sheet. Does anyone know how to acheive this? Thanks!!

_______________________________________________________
ORIGINAL ISSUE BELOW:
 
Hi
- copy the data
- insert it with 'Edit - Paste Special - Values'
 
You must log in or register to reply here.

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 "value" 1
VLOOKUP format issues? 4
Vlookup using concatenated values - Excel 2000 2
Vlookup and return sheet name also 2
How can I assign a value to a cell without putting a formula in it 4
VLOOKUP 2
Eliminate #N/A in Vlookup formulas 2
vlookup error 3

Back
Top