IF and Vlookup statments together

  • Thread starter Thread starter Don B
  • Start date Start date
D

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?
 
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
 
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 -
Click to expand...

I'm sorry, I was not paying attention.
 
Back
Top