example : =vlookup(A1;[200601]rates!$A1:$B20;2)
Problem : now I have to use the 'replace' function to change 200601 in 200602. Time consuming as this kind of 'replace' is to execute several times on more complexe vlookup formulas.
I tried to replace the 200601 by a variable that contains the YYYYMM (as cell headers). But when I use this in a vlookup formula, the vlookup act as a 'text string' and loss his functionality.
So my question : is there no way to use 'variables' in a vlookup formula ?
(variable is by example cell A2 where A2 contains a YYYYMM)
Excel version : 2003
Regards, Pirrbe
Problem : now I have to use the 'replace' function to change 200601 in 200602. Time consuming as this kind of 'replace' is to execute several times on more complexe vlookup formulas.
I tried to replace the 200601 by a variable that contains the YYYYMM (as cell headers). But when I use this in a vlookup formula, the vlookup act as a 'text string' and loss his functionality.
So my question : is there no way to use 'variables' in a vlookup formula ?
(variable is by example cell A2 where A2 contains a YYYYMM)
Excel version : 2003
Regards, Pirrbe