Using Text in formula by using the INDIRECT function

Using Text in formula by using the INDIRECT function in OpenOffice Calc

Additional Link


C7=1
D7="Sheet1"
E1=2
Reference Sheet Name="Sheet1"
Current Sheet Name="Summary"

Formula:
=VLOOKUP($C7; INDIRECT(CONCATENATE($D7;".$B$3:$I$21")); E$1; 0)