D
David
In one of the worksheets in my xls file, I have this formula:
=IF(ISERROR(VLOOKUP($A2,$K$1:$M$31,2,0)),"",VLOOKUP($A2,$K$1:$M$31,2,0)) in
columns B and C
The lookup table is in (on) the same worksheet. But I'd like to move the
table to another worksheet in the .xls file. If I do that, how must I
change the formula? The table I am referencing is K1 - M31.
=IF(ISERROR(VLOOKUP($A2,$K$1:$M$31,2,0)),"",VLOOKUP($A2,$K$1:$M$31,2,0)) in
columns B and C
The lookup table is in (on) the same worksheet. But I'd like to move the
table to another worksheet in the .xls file. If I do that, how must I
change the formula? The table I am referencing is K1 - M31.