formula copy or alternative solutions
Hi Arain,
Try:
=IF(VLOOKUP($B4,Perm,COLUMN())=0,"",VLOOKUP($B4,Pe rm,COLUMN()))
--
Cheers
macropod
[MVP - Microsoft Word]
"Arain" wrote in message ...
Dear All,
I have a formula that i have to copy to 146 columns.
=IF(VLOOKUP($B4,Perm,1)=0,"",VLOOKUP($B4,Perm,1))
is there a way to automate the 1 in the formula to 2 when i copy to column
to 2 .
The purpose of the formula is to look for B4 value in the sheet called
permission list and return the value associated with it which is X if false
and blank if true. Any and all help will be appreciated if the process is
automated somehow and i dont have to manually change the number.
Thanks in advance.
|