Need to use text typed in a cell C27 in formula Ex:Vlookup(C27..

J

Jacob Skaria

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
 

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

Averaging without #DIV0! 11
If condition for Blank Cell 4
XL2003: INDIRECT() function changes calling cell 0
Linking Columns between worksheets 6
Countif Help 8
vlooup formula and if(),isna etc 3
Macro to change column width and active window zoom as columns areselected 0
Problem is displaying formula 5

Top