Hello to every1. I am a new face here and a relative noob to excel.
Actually I use openoffice calc but its almost the same as excel...
my question, possibly a banal one for most here is:
how to make a part of the formula behave like variable?
example:
VLOOKUP(A1; 'SHEET1'.B1:C10; 2)
what i want to accomplish is this:
I want SHEET1 part to be variable, to be determined by value entered in another cell (say A2 in this .
so if i enter SHEET3 in A2, i want my formula to use that as a parameter inside VLOOKUP function.
I hope I was clear enough :/
Actually I use openoffice calc but its almost the same as excel...
my question, possibly a banal one for most here is:
how to make a part of the formula behave like variable?
example:
VLOOKUP(A1; 'SHEET1'.B1:C10; 2)
what i want to accomplish is this:
I want SHEET1 part to be variable, to be determined by value entered in another cell (say A2 in this .
so if i enter SHEET3 in A2, i want my formula to use that as a parameter inside VLOOKUP function.
I hope I was clear enough :/