{=IF(K8=AA11:AA21,VLOOKUP(K8,'Regular Assessment Table'!
I2:J12,2,FALSE))}

The above formula is looking up a K8 text content and returning a
vlookup value from a table. Part of the text I enter is "104(a)
Citation" and the formula return the correct value. But when I enter
"104(d)(1) Citation" the formula returns FALSE. For the life of me I
cannot determine why this is happening. Any ideas?