Extracting text from one file to another

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.
 
F

flummi

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
 

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

create a formula by using text from other cells 1
Move Comment into cell as Text 2
Copy information from one table to another table 1
VLookup 1
Transferring text from one worksheet to another 1
VLOOKUP 2
Extracting specific rows out of one worksheet based on an identifi 1
Vlookups and formats 3

Top