EXCEL MATCH EXACT 3 VALUES FROM 4 COLUMN

I WANT TO KNOW ABOUT EXCEL FORMULA WHICH CAN GET 3 (THREE) EXACT VALUES MATCH OUTPUT FROM OUT OF 4 COLUMS. 

EXAMPLE – EXCEL SCREEN ATTACHED.

 

  A B C D E
1 1103.6 1130.1 1124.3 1099.75 1138.85
2 1095.55 1080.5 1082.35 1080 1106.95
3 1072 1080 1076.85 1064 1091.7
4 895.1 899 895.85 885.2 902.55
5 1290.05 1307 1299.75 1287.25 1319
6 1971.25 1968 1962.7 1943.45 1973.6
7 1733.3 1742 1742.35 1724 1750.05
8 813 831.7 831.7 811.55 831.7
9 535.1 546.65 546.3 533.05 549.2
10 626.1 634 633.35 625 634
11 808.45 803.8 803.8 803.8 831
12 986.55 997 1006.05 976 997.8
13 1929 1936.5 1938.15 1926.9 1948.8
14 707.55 720 713.75 706.45 720.2
           

 

By: JUSTWIN

Leave a Reply

Your email address will not be published. Required fields are marked *