Need a formula

[AFZAL SOHAIL]

Dear Team:
1. I need a formula which search the entries from Col-A to Col-C and fill the col-F against the names in Col-e
2. In the Co-E the names comes more than three to four times, so fill col-F respectively
3. I am using the formulas =INDEX($C$2:$C$177,MATCH(A2,$F$2:$F$168,0)) but it is giving wrong values
Kindly help me, Thanks a lot in advance.

name​	Desgn​	osis​	epi​	osis id​	name​	Desgn​
Zulfiqar Ali​	Associate Network Technician​	700008044​	19600003	#N/A​	Farhan Khurshid​	Sr.Rigger​
muhammad Arif Anjum​	Associate Network Technician​	700010973​	19600003	#N/A​	Farhan Khurshid​	Sr.Rigger​
Muhammad Ilyas​	Associate Network Technician​	700014513​	19600003	700027136​	Imran Ahmad​	DRIVER​
RAI M Zergham KHAN​	Associate Network Technician​	700016523​	19600003	#N/A​	Imran Ahmad​	DRIVER​
Muhammad Tariq Hanif​	Associate Network Technician​	700018888​	19600004	#N/A​	Imran Ahmad​	DRIVER​
Abdul Hannan Ali​	Associate Network Technician​	700019145​	19600004	700016550​	Imran Ahmad​	DRIVER​
Muhammad Daud Malik​	Associate Network Technician​	700020781​	19600004	0​	Muhammad Adil Jahngir​	Technical Associate​
Syed Asad Ali​	Associate Network Technician​	700026141​	19701666	0​	Muhammad Adil Jahngir​	Technical Associate​
Talha Naveed​	Associate Network Technician​	700026368​	19701666	0​	Muhammad Adil Jahngir​	Technical Associate​
Arslan Ahmad​	Associate Network Technician​	700026825​	19701666	#N/A​	Muhammad Adil Jahngir​	Technical Associate​
Muhammad Husnain​	Associate Network Technician​	700027324​	19701666	#N/A​	Muhammad Adil Jahngir​	Technical Associate​
Muhammad Azeem​	Associate Network Technician​	700028662​	19701784	#N/A​	Muhammad Arslan​	Tech. Assist.​
Muhammad Asim​	Driver​	700007978​	19701784	700022194​	Muhammad Arslan​	Tech. Assist.​
Muhammad Shafiq​	Driver​	700007979​	19701784	#N/A​	Muhammad Arslan​	Tech. Assist.​
Imran Ahmed​	Driver​	700009327​	19701784	#N/A​	Muhammad Arslan​	Tech. Assist.​
Muhammad Amin shahid​	Driver​	700009328​	19701930	#N/A​	Muhammad Irfan​	SPLICER​
Nasir Arfat​	Driver​	700013506​	19701930	#N/A​	Muhammad Irfan​	SPLICER​
Hafiz Muhammad Imtiaz​	Driver​	700018698​	19701930	700022891​	Muhammad Irfan​	SPLICER​
Ali Raza​	Driver​	700022795​	19701930	#N/A​	Muhammad Irfan​	SPLICER​
Imran Karamat​	Driver​	700022796​	19701930	0​	Muhammad Akmal​	Tech. Assist.​
Rana Muhammad Mubeen Ud Din​	Driver​	700026084​	19702240	0​	Muhammad Akmal​	Tech. Assist.​
Muhammad Adnan​	Driver​	700026858​	19702240	0​	Muhammad Akmal​	Tech. Assist.​
Muhammad Kashif​	Manager - Fiber Operations​	700026004​	19702240	0​	Muhammad Akmal​	Tech. Assist.​
Hassan Ali​	Network Technician​	700013161​	19702240	0​	Muhammad Akmal​	Tech. Assist.​
Muhammad Irfan​	Splicer​	700014324​	19702368	700009328​	Muhammad Akmal​	Tech. Assist.​
Yasir Ali​	Splicer​	700014547​	19702368	#N/A​	Muhammad Akmal​	Tech. Assist.​
Muhammad Sajjad​	Splicer​	700016418​	19702368	700014323​	Yasir Ali Malik​	SPLICER​
Muhammad Asim Shahzad​	Splicer​	700021032​	19702368	#N/A​	Yasir Ali Malik​	SPLICER​
Muhammad Ahsan​	Splicer​	700022498​	19702369	#N/A​	Yasir Ali Malik​	SPLICER​
Muhammad Imran​	Splicer​	700024210​	19702369	0​	Yasir Ali Malik​	SPLICER​

 

[hagia_sofia]

Based on your original formula is it not like this?

=INDEX($C$2:$C$177,XMATCH(F2,$A$2:$A$177,0))

On top of that is column B decisive to match those names or not - 1. seems to suggest it, but 3. does not.

 

[AFZAL SOHAIL]

Based on your original formula is it not like this?

=INDEX($C$2:$C$177,XMATCH(F2,$A$2:$A$177,0))

On top of that is column B decisive to match those names or not - 1. seems to suggest it, but 3. does not.

Thanks a lot medam, I check it and reply

 

[AFZAL SOHAIL]

Dear Medam,
The formula is working some cell ok, and some cell not giving the result,
e,g If col-A Imran Ahmad and in col-F Imran Ahmed it is giving N/A, it is possible to is not case sensitive I mean It can ignore
the difference between Imran Ahmad and Imran Ahmed and also same more cells

 

[hagia_sofia]

Dear Medam,
The formula is working some cell ok, and some cell not giving the result,
e,g If col-A Imran Ahmad and in col-F Imran Ahmed it is giving N/A, it is possible to is not case sensitive I mean It can ignore
the difference between Imran Ahmad and Imran Ahmed and also same more cells

"Imran Ahmad" and "Imran Ahmed" is not a question of case sensitive, those names differ - AhmAd and AhmEd. How it possible to tell that they are the same person? Or is it a typo mistake?

 

[AFZAL SOHAIL]

"Imran Ahmad" and "Imran Ahmed" is not a question of case sensitive, those names differ - AhmAd and AhmEd. How it possible to tell that they are the same person? Or is it a typo mistake?

Ok Medam, I understand this point.