Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup issue
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. 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup issue
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup issue
i was looking in the whole table. how can i define it?
"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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup issue
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" wrote: 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,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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup issue
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Discussion (Misc queries) | |||
VLOOKUP ISSUE - Take II | Excel Worksheet Functions | |||
VLOOKUP ISSUE | Excel Worksheet Functions |