Formula help

[bnageshrao]

I made a spreadsheet by combining two files and it looks like as shown below

F.Name1 L.Name1 F.Name2 L.Name2 Match
John Reed Nancy Lu Y
Mike Dandy Kathy Rino N
Levy Nick James Mitch N
Lou Rice Long Lee Y
Kathy Rino David Wyne Y
James Mitch Lou Rice Y
Long Lee John Reed Y

If there is a match between F.Name1 and L.Name1 to F.name2 and L.Name2 in the range then Y is enterd in Match column or else N is entered. F.Name 1 and L.Name1 shoulkd match to F.Name2 and L.name2 at the same time.

If some once can write a sample formula to achieve the same I will be grateful. Thanks in advance.

 

[AnotherHiggins]

What are you trying to accomplish with this? Do you just want to get down to a unique set of records?

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[bnageshrao]

I am trying to find the invalid users. First file is the combined list of valid and invalid users
and second file is the list of valid users . SO if the first file has values in 2nd file that means he is a valid use and hence I put Y for match, if not found I put N for no match.

 

[SkipVought]

Hi,

Ahhhhhh.

You really have 2 lists.

List one is valid & invald user name and list two is valid names.

There is NO RELATIONSHIP between the two names on the same row.

So if they were in separate tables on separate sheets, you could use MS Query (Data/get External Data/New Database Query/Excel files -- YOUR WORKBOOK......) to find the unique valid occurrences.

Should take about 30 seconds.

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]