IF and Vlookup statments together

[Don B]

={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?

 

[Tom van Stiphout]

On Fri, 9 Oct 2009 06:54:17 -0700 (PDT), Don B

Ask your question in an Excel-related newsgroup. This one is for the
Microsoft Access database product. We could give you the SELECT
statement

-Tom.
Microsoft Access MVP

 

[Don B]

On Fri, 9 Oct 2009 06:54:17 -0700 (PDT), Don B


Ask your question in an Excel-related newsgroup. This one is for the
Microsoft Access database product. We could give you the SELECT
statement

-Tom.
Microsoft Access MVP





- Show quoted text -

I'm sorry, I was not paying attention.