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.