So i need the value of column 1 displayed when two other items in a row match.
Right now I can get the first matched row to display, but I cannot figure out how to display the last in a list.
here is my formula: {=INDEX(Diesel!$A$36:$T$5000,MATCH(1,(Diesel!$G$36:$G$5000="T-64")*(Diesel!$H$36:$H$5000="release"),0),1)}
Thanks!
Bookmarks