How do I create a new list from previous results?

[Nobby]

A bit long this question - because I don't know exactly what I'm looking for!I have compared 2 lists of names and, using a formula provided by this forum, have identified those people who either do or do not reside on both lists.

So, Col A = List of Names 1
Col B = List of Names 2
Col C = result of this function:
=IF(ISNUMBER(MATCH(A1,$B$1:$B$240,0)),"Yes","No")

I now want to create a list that just shows the Names which have a "No" against them. I could just use Filters, but I need something more permanent.

The following function gave me a result for the 1st entry only:

=VLOOKUP("No",A1:C240,1)

I just want it to move on down the list and identify the next name to be added. So, its a bit like getting it to add extra lines for every new entry it finds.

Can someone point me in the right direction?

ta

 

[Aladin Akyurek]

On 2002-02-27 12:25, Nobby wrote:
A bit long this question - because I don't know exactly what I'm looking for!I have compared 2 lists of names and, using a formula provided by this forum, have identified those people who either do or do not reside on both lists.

So, Col A = List of Names 1
Col B = List of Names 2
Col C = result of this function:
=IF(ISNUMBER(MATCH(A1,$B$1:$B$240,0)),"Yes","No")

I now want to create a list that just shows the Names which have a "No" against them. I could just use Filters, but I need something more permanent.

The following function gave me a result for the 1st entry only:

=VLOOKUP("No",A1:C240,1)

I just want it to move on down the list and identify the next name to be added. So, its a bit like getting it to add extra lines for every new entry it finds.

Can someone point me in the right direction?

ta

Try:

In D1 enter and copy down:

=IF(C1="No",VLOOKUP(A1,$B$1:$B$240,0),"")