Hi,
I have this formula
=IF(ISNA(VLOOKUP($A10,INDIRECT($P1&"!A:j"),4,0)=TRUE),0,VLOOKUP($A10,INDIRECT($P1&"!A:j"),4,0))
but I would like to have the column index number variable, so that when I change a look up it will go to another column.
I have data in columns 4 through to 10 and would like to select it by column.
is this something that can be done?
Regards,
I have this formula
=IF(ISNA(VLOOKUP($A10,INDIRECT($P1&"!A:j"),4,0)=TRUE),0,VLOOKUP($A10,INDIRECT($P1&"!A:j"),4,0))
but I would like to have the column index number variable, so that when I change a look up it will go to another column.
I have data in columns 4 through to 10 and would like to select it by column.
is this something that can be done?
Regards,