Thanks:  0
Likes:  0

# Thread: How do I create a new list from previous results?

1. 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

2. 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),"")

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•