Thread
:
convert value stored as text to logical refrence value!
View Single Post
#
2
Don Guillett
Posts: n/a
have a look in help index for INDIRECT
--
Don Guillett
SalesAid Software
"Remote Desktop Connection hotkey"
ft.com wrote in message
...
I want to read variable from cell. Is it possible to convert value stored
as
text to logical refrence value!
For example
I want to use this forumla
=HLOOKUP("Currency";table1;1;FALSE)
But i want to read RANGE TABLE name from another cell - i want it to be
variable
IF i store table1 in cell A4 and write formula
=HLOOKUP("Currency";A4;1;FALSE) then i get error cuz it reads "table1" and
thinks i supply text but i want to supply reference value which is table1
not
"table1"
Maybe there is way to store text in cell as reference value ?
Reply With Quote