Tony, I tried but my browser decided to mess with me regarding the 10 character min that the edit requires. Either way, I messed up and won't delete it now. It will forever be a mark of shame against my internet permanent record .
Rajn - Tony was basically pointing out that my initial post won't work because the OR() function returns the binary value of True/False and will result in an error where I put it. This one has more thought put into it and I think it will work:
Formula:
{=IFERROR(INDEX(A128TP[STATUS],MATCH(TESTSTATUS[[#This Row],[TP NO]],IF(Or(A128TP[STATUS]<>"INITIAL REJECT",A128TP[STATUS]<>"Prev Rev"),A128TP[TP NO]),0)),"")}
Bookmarks