DEAR ALL,
I HAD FORMULATED INDEX, MATCH FORMULA & RETURN VALUE IS TEXT VALUE. BUT IF TEXT STRING IS VERY LONG, THEN RETURN VALUE IS SHOWS LIKES THIS "############################". PLEASE HELP ME TO RESOLVE THIS ISSUE.
A B
1 Location Text
2 Chennai Chennai, on the Bay of Bengal in eastern India, is the capital of the state of Tamil Nadu.
3 Madurai Madurai is an energetic, ancient city on the Vaigai River in the South Indian state of Tamil Nadu. Its skyline is dominated by the 14 colorful gopurams (gateway towers) of Meenakshi Amman Temple.
INDEX(B2:B3,MATCH("Madurai",A2:A3,0),MATCH("Text",B2:B3,0)
Regards,
Balaji K
Bookmarks