Iterate over column to find if a value is in there? (Google Sheets)-CodePudding

In a column I want to iterate over say row 1-7 to see if it contains value A. If it contains value A I want to print value C. If FALSE I want to check say row 8 - 10,and if TRUE i want to print value D. If FALSE I want to continue to row 11 - 20, and if TRUE print value E and so on... See this link for clarification:

CodePudding user response：

It seems to me that this would produce the result you want:

=VLOOKUP(J2,FILTER(F2:G,G2:G<>""),2,TRUE)

This should work because your values in F2:F run smallest to largest without exception.