Prev: General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
Next: Days in Text to Dates SPECIAL
From: Dawn Mann Dawn on 13 Apr 2010 16:35
Hi,

I have a list of companies, need to look at a separate list of countries
and, if any of the companies are in countries found in that list, I want to
highlight the cell containing the company country value.

Basically, I need a formula that looks at the company country value, then
searches the entire list of countries to find a match.

I've got over 10,000 companies in one list and 100+ countries in the second
list.

Dawn
From: Steve Dunn on 14 Apr 2010 06:28
untested, assumes your list of countries is called "countries" and the
company countries column is E.

=match($E1,countries,0)




"Dawn Mann" <Dawn Mann(a)discussions.microsoft.com> wrote in message
news:D6DDAB4F-F8CD-4136-9EEC-C402F989B8B2(a)microsoft.com...
> Hi,
>
> I have a list of companies, need to look at a separate list of countries
> and, if any of the companies are in countries found in that list, I want
> to
> highlight the cell containing the company country value.
>
> Basically, I need a formula that looks at the company country value, then
> searches the entire list of countries to find a match.
>
> I've got over 10,000 companies in one list and 100+ countries in the
> second
> list.
>
> Dawn

 | 
Pages: 1
Prev: General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
Next: Days in Text to Dates SPECIAL