Vlookup issue
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
On Aug 5, 4:44*pm, 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,P erm,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.
|