Finding value from large string

[#1]

Hello All,

I need urgent help on finding District and Village information from the address based on Mater table.

My requirement is mentioned below based on attached sheet;

1) Master tab include master information of State, District and Village information which is the master information

2) Second tab include address information from which Master table need to be mapped. For example; Master table is having Stage as Maharashtra, District as Mumbai and Village as Andheri and want to search similar information in Address tab. If Address values matches with Master table then i would like to do tag it with Confirm, if not then probable

Thanks in advance.

Regards,

Imran Khan

[robert_mika]

Are all your data in the same format?

last three words describe the output?

[#3]

Thanks Robert for your quick response.

No Robert. The output which i am looking for, can be at any part of the address.

[robert_mika]

Could you post more examples?

[avinashelite]

please find the attachment for the solution

Hope this helps you

[#6]

I am unable to find any attachment.

[avinashelite]

please see now