How to search for a value if exists or not in google sheets-CodePudding

Home > Blockchain > How to search for a value if exists or not in google sheets

How to search for a value if exists or not in google sheets

Time：02-05

I have two things:

I need to check if a specific section exist in specific category or not:

example:

How to get status result if Exists or Not?

CodePudding user response：

try:

=INDEX(IF(A4:A="";;IF(IFNA(VLOOKUP(A4:A&B4:B; 
 FLATTEN(G3:H3&G4:H); 1; 0))=""; "none"; "exists")))

CodePudding user response：

Another option:

=INDEX(IF(LEN(A2:A),IF(COUNTIF(INDEX($F$2:$G,,MATCH(A2:A,$F$2:$G$2,0)),B2:B),"Exists","None"),))