ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need to use text typed in a cell C27 in formula Ex:Vlookup(C27.. (https://www.excelbanter.com/excel-worksheet-functions/244993-need-use-text-typed-cell-c27-formula-ex-vlookup-c27.html)

Excel Help

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

Luke M

Need to use text typed in a cell C27 in formula Ex:Vlookup(C27..
 
take a look at using the INDIRECT function in XL help file.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"excel help" wrote:

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


Jacob Skaria

Need to use text typed in a cell C27 in formula Ex:Vlookup(C27..
 
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
---------------
Jacob Skaria


"excel help" wrote:

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



All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com