Extracting text from one file to another

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

Guest

Is there a way to use VLookup to extract text? I have a PN on my current
worksheet that I'd like to lookup in another, then pull the text comments
from the other worksheet. VLookup only pulls numbers instead of text.
 
Vlookup delivers anything that is in the column you told it to take a
value from.

=Vlookup(a5;range;4;false)

looks up the search value in A5 in the table named "range" and puts
what it finds in column 4 of the line where it found the search value
into the cell of your formula.

Hans
 
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

Vlookups and formats 3
create a formula by using text from other cells 1
Copy information from one table to another table 1
extract text between 2 tags 2
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ? 3
Extracting specific rows out of one worksheet based on an identifi 1
Transferring text from one worksheet to another 1
vlookup to txt file or database 5

Back
Top