Hi marty,
Great formula given by icestation, but I personally like vlady's solution... here's a modified version... that might work for you...
=IFERROR(INDEX($F$3:$F$12,MATCH(G3&I3&J3,$A$3:$A$12&" "&$B$3:$B$12&" "&$C$3:$C$12&$D$3:$D$12&$E$3:$E$12,0)),IFERROR(INDEX($F$3:$F$12,MATCH(H3&I3&J3,$A$3:$A$12&" "&$C$3:$C$12&$D$3:$D$12&$E$3:$E$12,0)),"not found"))
ctrl-shift-enter
vlady - didn't mean to step on your work, I just wanted to give marty a solution...
Bookmarks