Try
C3=IFERROR(INDEX(INPUTS!$E$2:$E$18,IFERROR(MATCH(OUTPUT!C$2&OUTPUT!$B3,INDEX(INPUTS!$B$2:$B$18&INPUTS!$C$2:$C$18,),0),MATCH(OUTPUT!C$2&OUTPUT!$B3,INDEX(INPUTS!$B$2:$B$18&INPUTS!$D$2:$D$18,),0))),"")
Try
C3=IFERROR(INDEX(INPUTS!$E$2:$E$18,IFERROR(MATCH(OUTPUT!C$2&OUTPUT!$B3,INDEX(INPUTS!$B$2:$B$18&INPUTS!$C$2:$C$18,),0),MATCH(OUTPUT!C$2&OUTPUT!$B3,INDEX(INPUTS!$B$2:$B$18&INPUTS!$D$2:$D$18,),0))),"")
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks