Sir,
I long posted a question and found answer in (/forum/excel-questions/1036441-match-nested-if-vlookup-2.html). I have gone to the next step and wrote this (if)conditional code by myself which is very long. How can I shorten it? I am getting data to sheet3 from paymatrix sheet in the same workbook. If possible, please help me shortening the code. Thanks. Code is given below:
IF(C6=1900,INDEX(paymatrix!$A$3:$A$19,IFNA(MATCH(D6,paymatrix!$A$3:$A$19,0),MATCH(D6,paymatrix!$A$3:$A$19,1)+1)),
IF(C6=4200,INDEX(paymatrix!$B$3:$B$19,IFNA(MATCH(D6,paymatrix!$B$3:$B$19,0),MATCH(D6,paymatrix!$B$3:$B$19,1)+1)),
IF(C6=4600,INDEX(paymatrix!$C$3:$C$19,IFNA(MATCH(D6,paymatrix!$C$3:$C$19,0),MATCH(D6,paymatrix!$C$3:$C$19,1)+1)),
IF(C6=5400,INDEX(paymatrix!$D$3:$D$19,IFNA(MATCH(D6,paymatrix!$D$3:$D$19,0),MATCH(D6,paymatrix!$D$3:$D$19,1)+1)),
IF(C6=6600,INDEX(paymatrix!$E$3:$E$19,IFNA(MATCH(D6,paymatrix!$E$3:$E$19,0),MATCH(D6,paymatrix!$E$3:$E$19,1)+1)))))))
I long posted a question and found answer in (/forum/excel-questions/1036441-match-nested-if-vlookup-2.html). I have gone to the next step and wrote this (if)conditional code by myself which is very long. How can I shorten it? I am getting data to sheet3 from paymatrix sheet in the same workbook. If possible, please help me shortening the code. Thanks. Code is given below:
IF(C6=1900,INDEX(paymatrix!$A$3:$A$19,IFNA(MATCH(D6,paymatrix!$A$3:$A$19,0),MATCH(D6,paymatrix!$A$3:$A$19,1)+1)),
IF(C6=4200,INDEX(paymatrix!$B$3:$B$19,IFNA(MATCH(D6,paymatrix!$B$3:$B$19,0),MATCH(D6,paymatrix!$B$3:$B$19,1)+1)),
IF(C6=4600,INDEX(paymatrix!$C$3:$C$19,IFNA(MATCH(D6,paymatrix!$C$3:$C$19,0),MATCH(D6,paymatrix!$C$3:$C$19,1)+1)),
IF(C6=5400,INDEX(paymatrix!$D$3:$D$19,IFNA(MATCH(D6,paymatrix!$D$3:$D$19,0),MATCH(D6,paymatrix!$D$3:$D$19,1)+1)),
IF(C6=6600,INDEX(paymatrix!$E$3:$E$19,IFNA(MATCH(D6,paymatrix!$E$3:$E$19,0),MATCH(D6,paymatrix!$E$3:$E$19,1)+1)))))))