PDA

View Full Version : Formula Index, Match and Partial Match four columns



kumarxcelv
10-20-2016, 03:30 PM
Hi Friends,

Looking for formula to Index, Match and partial match data.
Match A and C columns and Partial match D to B columns.
I included sample attachment with Red highlighted text matched and partial match and get column E data and copy against row match

17383

Thanks
Kumar

mana
10-21-2016, 03:49 AM
Can I ask you what the numbers mean?
345. 478, 899

kumarxcelv
10-21-2016, 07:18 AM
they are roll numbers or emails anything just assume it as text.