| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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..
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| # symbol appearing instead of typed text in a cell | Excel Discussion (Misc queries) | |||
| Rows expand to fit text typed in? | Excel Discussion (Misc queries) | |||
| Typed or pasted text in a cell appears as #### | Excel Discussion (Misc queries) | |||
| Inserting characters into text already typed | Excel Discussion (Misc queries) | |||
| Excel merged cell - can it automatically expand as text is typed? | New Users to Excel | |||
Linear Mode
