M
M Flynn
is there anyway to index across multiple tabs in Excel?
The Lotus function i want to convert is @INDEX
($01:$c$21..$30:$v$21,C$71,0,$p35) where the "01"
and "30" are the first and last tabs of the groups i want
to index through. Ive tried =INDEX('01'!$C$21:'30'!
$V$21,C$71,0,$P35) in Excel with no luck - a "VALUE"
error. Is this function possible in Excel? thanks...
The Lotus function i want to convert is @INDEX
($01:$c$21..$30:$v$21,C$71,0,$p35) where the "01"
and "30" are the first and last tabs of the groups i want
to index through. Ive tried =INDEX('01'!$C$21:'30'!
$V$21,C$71,0,$P35) in Excel with no luck - a "VALUE"
error. Is this function possible in Excel? thanks...