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. |
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 |