cells a1 = apple a2 = pear =VLOOKUP($C8,'1. COM SERVICE'!$C$4:$J$25,6) I need to make '1. COM SERVICE' variable. VLOOKUP($C8,'a1'!$C$4:$J$25,6) so it would be VLOOKUP($C8,'apple'!$C$4:$J$25,... RobMoore67 You may use INDIRECT, as variant =VLOOKUP($C8,INDIRE...
Each section takes a large interval with a certain value as the starting point, and extends to both sides with the center of the large interval as the center; The positioning is moved to the value range for median or average value; The software has a separate database that can hold ...
a1 = apple a2 = pear =VLOOKUP($C8,'1. COM SERVICE'!$C$4:$J$25,6) I need to make '1. COM SERVICE' variable. VLOOKUP($C8,'a1'!$C$4:$J$25,6) so it would be VLOOKUP($C8,'apple'!$C$4:$J$25,6) VLOOKUP($C8,'a2'!$C$4:$J$25,6) so it would be VLOOKUP($C8,'p...
cells a1 = apple a2 = pear =VLOOKUP($C8,'1. COM SERVICE'!$C$4:$J$25,6) I need to make '1. COM SERVICE' variable. VLOOKUP($C8,'a1'!$C$4:$J$25,6) so it would be VLOOKUP($C8,'apple'!$C$4:$J$25,... RobMoore67 You may use INDIRECT, as variant =VLOOKUP($C8,INDIRE...