Project Detail

Description

I need an urgent solution.

Only for those who have advanced knowledge in excel operation with coding.

I have some data in excel sheet. There 're several column, containing firms contact info, also there are two column at the end, legal area and language. I need to work with these two column.
Each firm has its some legal areas and different language services.

Say for the firm, FERNANDO SCORNIK GERSTEIN SPANISH LAWYERS,(check the attachment) it provides service in Clinical Negligence,Commercial litigation,Civil Education,Conveyancing residential,Immigration law,Civil litigation,Tax law,Wills and probate, so under those legal ares you will find "YES" and for others legal areas which they don't provide service, find "NO". Also the same for the languages, this firm use French,Spanish, not other languages.So put "YES" for French,Spanish and "NO" for the other languages.

Now i need the operation automated. Each legal area and language will search for that service in the firm which listed on column B, if the firm provide the service, than return "YES", if not than return "NO". I have the database of each company's legal area and language services. So there will be a coding necessary for this.

I need this within 24 hours and i will be select coder within few hours.

Thanks all.


Additional files submitted:
firmdata.xls