searching for text and returning information

D

Doug

I have columns A thru G in file 1. In file 2, I want to search column "G" in
file 1 and find either El Salvador or EDP_SIGMA(pertains to El Salvador) and
return what is in column "A" if it finds either of those options. Basically,
I'm searching through a list of countries (Column G) and returning the
information only pertaining to El Salvador. I'm making a separate file for
each country, but, some countries have more than one option.

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top