Using INDEX & MATCH formula in excel for multiple value comparison:

Example:

Source Table Array as per below:

Employee Name	Basic	DA	Trans	PF	Total
Joseph	5000	2500	1000	600	9100
McCulum	7000	3500	1000	840	12340
Denial	9000	4500	1000	1080	15580
Desosa	12000	6000	1000	1440	20440
Rechard	15000	7500	1000	1800	25300

Now same formula add in every cell only column no. change as per required data

 

See Above formula in formula bar I have using multiple value comparison and given Total