it has about 151 coulmns

"Gord Dibben" wrote:

What is the table range you have defined as "Perm"?

How many columns does it contain?


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 08:44:01 -0700, Arain
wrote:

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.