Vlookup or vba or code

[Vishaal]

Thanks in advance

I am using the following vlookup

Lookup value = C10
Table array =sheet1!$B$2:$GKX$5
Col index = 5041
Range lookup=0

Now problem is
I want to change the table array "sheet1!$B$2:$GKX$5" for coloumn from B to GKW

And also change the coloumn index accordingly, like 5040, 5039

 

[mohadin]

Nop
The site in not working here
Can you show in #17 the expected result

 

[Vishaal]

ok

tried but not working

i m attaching the screen shot

Excel 2010 32 bit

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ] [/COLOR]	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]H[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]I[/COLOR]​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​					102​	105​	102​	109​	401​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​					35​	654​	824​	38​	302​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​					379​	807​	202​	90​	288​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​					160​	305​	103​	3​	201​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​					205​	205​	206​	207​	106​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​						​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​	​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​	​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​	​	​	379​	​	#REF!​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​	​	​	807​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​	​	​	811​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​	​	​	414​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​	​	​	218​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​	​	​	386​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​	​	​	824​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​	​	​	474​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​	​	​	476​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​	​	​	357​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR]​	​	​	90​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR]​	​	​	71​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR]​	​	​	711​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]23[/COLOR]​	​	​	341​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]24[/COLOR]​	​	​	288​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]25[/COLOR]​	​	​	762​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]26[/COLOR]​	​	​	747​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]27[/COLOR]​	​	​	47​	​	​
#E0E0F0[/URL] ] [COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]28[/COLOR]​	​	​	765​	​	​

#E0E0F0[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ] #FFFFFF[/URL] ]

Sheet: Sheet1

you know all the thing, formula in e10 is given below, which i am using

Excel 2010 32 bit
	E
10	#REF!
Sheet1

Cell Formulas
Range	Formula
E10	=VLOOKUP(C10,E2:I6,6,0)

i think if will copy this data in excel and check and provide a url to view or use the file, it will great...............

 

[Fluff]

How about in E10 copied down & across
=IF(ISNUMBER(MATCH($C10,E$2:E$6,0)),"yes","No")

 

[Vishaal]

Thanks Fluff Sir Ji,

Its working

Great..............

 

[Vishaal]

Thanks mohadin Sir Ji

 

[Peter_SSs]

i m attaching the screen shot

What are you using for that screen shot?
Why not use what was successful in post 5 of your thread in the Test Here forum?

 

[mohadin]

Put this where #Ref !
=IFNA(VLOOKUP(INDIRECT(ADDRESS(ROW();COLUMN()-2));INDIRECT(ADDRESS(4;COLUMN())&":"&"$k$7");COLUMN()-5;0);"NO")

 

[Fluff]

Thanks Fluff Sir Ji,

Its working

Great..............

You're welcome & thanks for the feedback

 

[Vishaal]

What are you using for that screen shot?
Why not use what was successful in post 5 of your thread in the Test Here forum?

I have tried to post that but mistakenly posted the second screen shot

Thanks for your help Sir

 

[Peter_SSs]

I have tried to post that but mistakenly posted the second screen shot

Thanks for your help Sir

That did not answer my question of "What are you using for that screen shot?"