ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   searching for text and returning information (https://www.excelbanter.com/excel-discussion-misc-queries/247975-searching-text-returning-information.html)

Doug

searching for text and returning information
 
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.


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com