close
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 quot;rangequot; and puts
what it finds in column 4 of the line where it found the search value
into the cell of your formula.
Hans
全站熱搜
留言列表
