Vlookup issue
Can someone please help me. my last problems is still unsolved. would really
appreciate
the formula works till "AX" column and crashes. is there any limitation to
vlookup
"macropod" wrote:
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.
|