I am trying to add an if function to my vlookup.

current formula: =vlookup("*treasury*",'January (1/22)'!B:E,4,false)

I want to add another condition for it to check if the row that the information exist on is check marked (column "J" in this example). If so, then display the vlookup.

My column "J" has checkboxes.

CodePudding user response：

try:

=IFNA(FILTER(Sheet1!E2:E, Sheet1!J2:J=TRUE, REGEXMATCH(Sheet1!B2:B, "(?i)treasury")))