Hi,

What result does the INDEX() and MATCH() throw up?

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Govind" wrote in message
...
"=INDEX(Rawdata,MATCH(Q24,'Raw Data'!BR15:BR1226,0),MATCH(Common!$A$7,'Raw
Data'!$A$1:$BR$1,0))" formula

Cell "Q24" is a text which has almost 40 characters which is the only
common
field in the data for which I am looking for.

Q24 "ABCDEFGABCDEFGABCDEFGABCDEFGABCDEFGABCDEFGABC DEFG
ABCDEFGABCDEFGABCDEFGABCDEFGABCDEFGABCDEFGABCDEFGA BCDE FGABCDEFG ABCDEFG
ABCDEFG"

"Jacob Skaria" wrote:

Can you post an example and the formula you are using..

If this post helps click Yes
---------------
Jacob Skaria


"Govind" wrote:

In a index or match function if I have almost 40 characters it does not
give
me the values am looking for. Is there a limit on the characters? if
Yes,
then whats the solution?