Hi Mr. Excel,
Is there a way to change different table arrays from multiple vlookup to a one comman table array?
Let's say the formula looks like this:
=IFERROR(VLOOKUP($824,'Report'!$A:$BT, 72,0),0)+FERROR(VLOOKUP($824,'Report'!$A:$DJ,114,0),0)+FERROR(VLOOKUP($824, 'Report'!$A:$DQ,121,0),0)
The table arrays are:
$A:$BT
$A:$DJ
$A:$DQ
Since these are fixed arrays, I no longer need to lookup one by one, but just use a single table array $A:$DQ.
Is there a way or at least a tool in the ribbon? That can help me change these table arrays to $A:$DQ simultaneously?
Is there a way to change different table arrays from multiple vlookup to a one comman table array?
Let's say the formula looks like this:
=IFERROR(VLOOKUP($824,'Report'!$A:$BT, 72,0),0)+FERROR(VLOOKUP($824,'Report'!$A:$DJ,114,0),0)+FERROR(VLOOKUP($824, 'Report'!$A:$DQ,121,0),0)
The table arrays are:
$A:$BT
$A:$DJ
$A:$DQ
Since these are fixed arrays, I no longer need to lookup one by one, but just use a single table array $A:$DQ.
Is there a way or at least a tool in the ribbon? That can help me change these table arrays to $A:$DQ simultaneously?