Here's what I tried without success (not using the LEFT function):
=IF(AND(INDEX('TABLE'!C:C,MATCH("701-000021-103",'TABLE'!C:C)),INDEX('TABLE'!C:C,MATCH("2",'TABLE'!G:G))),"X","")
Here's what I tried without success (not using the LEFT function):
=IF(AND(INDEX('TABLE'!C:C,MATCH("701-000021-103",'TABLE'!C:C)),INDEX('TABLE'!C:C,MATCH("2",'TABLE'!G:G))),"X","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks