Help: Multiple criteria involving strings

I have an error in the file already called 'ambiguous name detected' it always appears when I change some cell. Does that help?

#value!

Originally Posted by sktneer

Try this formula.....

=RIGHT(INDEX(Sheet1!$H$4:$H$90000,MAX(IF(IF(Sheet1!$H$4:$H$90000<>"",LEFT(Sheet1!$H$4:$H$90000,4)*1)=MAX(IF(Sheet1!$H$4:$H$90000<>"",LEFT(Sheet1!$H$4:$H$90000,4)*1)),IF(Sheet1!$J$4:$J$90000="committed",ROW(Sheet1!$H$4:$H$90000)-ROW(Sheet1!$H$4)+1)))),2)

Don't forget to enter it with Ctrl+Shift+Enter.

Does this help?