Hi All,
Can anyone tell me how to use the text content of one cell as a variable part of a lookup.
I have this external lookup
'[Stock Prices.xls]STO'!$M$3
with "STO" a variable stock code as text in a cell as well as the name of a sheet in Stock Prices.xls
What I would like to do is have a variable in the lookup rather than "STO"
Any ideas ??
Thanks
Peter
Can anyone tell me how to use the text content of one cell as a variable part of a lookup.
I have this external lookup
'[Stock Prices.xls]STO'!$M$3
with "STO" a variable stock code as text in a cell as well as the name of a sheet in Stock Prices.xls
What I would like to do is have a variable in the lookup rather than "STO"
Any ideas ??
Thanks
Peter