Vlookup issue

  • Thread starter Thread starter Arain
  • Start date Start date
A

Arain

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

:

Hi Arain,

Try:
=IF(VLOOKUP($B4,Perm,COLUMN())=0,"",VLOOKUP($B4,Perm,COLUMN()))

--
Cheers
macropod
[MVP - Microsoft Word]


"Arain" <[email protected] 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.
 
What sort of hardware are you running this on?
I'm afraid spreadsheets are just not meant for these types of tasks.
Do you have the options of using a database? They're much faster and
more reliable in these cases.
 
What do you mean by "crashes"? Do you get an error message? If so,
what is it?

Presumably Perm is a named range - how many columns is it defined for?
(check with Insert | Name | Define and then select it from the list).

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

How many columns does it contain?


Gord Dibben MS Excel MVP
 
i was looking in the whole table. how can i define it?

Gord Dibben said:
What is the table range you have defined as "Perm"?

How many columns does it contain?


Gord Dibben MS Excel MVP

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

:

Hi Arain,

Try:
=IF(VLOOKUP($B4,Perm,COLUMN())=0,"",VLOOKUP($B4,Perm,COLUMN()))

--
Cheers
macropod
[MVP - Microsoft Word]


"Arain" <[email protected] 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.
Click to expand...
Click to expand...
 
the error is that it can not reference to the right cell or the cell has
moved or been deleted. i am willing to share the file if someone can help
with it.

Pete_UK said:
What do you mean by "crashes"? Do you get an error message? If so,
what is it?

Presumably Perm is a named range - how many columns is it defined for?
(check with Insert | Name | Define and then select it from the list).

Pete

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

:

Hi Arain,

Try:
=IF(VLOOKUP($B4,Perm,COLUMN())=0,"",VLOOKUP($B4,Perm,COLUMN()))

--
Cheers
macropod
[MVP - Microsoft Word]

"Arain" <[email protected] 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.
Click to expand...
Click to expand...
 
it has about 151 coulmns

Gord Dibben said:
What is the table range you have defined as "Perm"?

How many columns does it contain?


Gord Dibben MS Excel MVP

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

:

Hi Arain,

Try:
=IF(VLOOKUP($B4,Perm,COLUMN())=0,"",VLOOKUP($B4,Perm,COLUMN()))

--
Cheers
macropod
[MVP - Microsoft Word]


"Arain" <[email protected] 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.
Click to expand...
Click to expand...
 
Back
Top