Otherwise I'd think this would work for you... =IF(AND(table!G2=2,LEFT(table!C2,11)="701-000021-"),"X","")
Otherwise I'd think this would work for you... =IF(AND(table!G2=2,LEFT(table!C2,11)="701-000021-"),"X","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks