J Jacob Skaria Oct 8, 2009 #3 Please elaborate your question. There is nothing in that description. If you mean to lookup the text string (part of the actual text) types in a cell you can use wildcards as below... =VLOOKUP("*" & C27 & "*",A:B,2,0) If this post helps click Yes
Please elaborate your question. There is nothing in that description. If you mean to lookup the text string (part of the actual text) types in a cell you can use wildcards as below... =VLOOKUP("*" & C27 & "*",A:B,2,0) If this post helps click Yes