Haha. I have been working on this for so long and got to =IF(AND(A1=A2,B1="New",B2="TA Screen"),vlookup( and I thought my brain was going to explode.

So simple. Thanks.