can i use filters to compare data instead of vlookup?

[Vindell]

I have to compare membership lists to identify if customers belong to certain
groups. Currently, I have been using Vlookup but I notice that there are too
many nuisances. Could I use a filter to compare two membership lists and give
me a more accurate answer?

[CLR]

Maybe try setting up a new sheet with List1, and entering a new column
indicating List1 in each row......then adding List 2 at the bottom and
entering List2 in the new column for each row in that section............then
do Data > Filter > AutoFilter and check the arrows at the tops of the columns
to filter from there........it may do what you're looking for.........

Vaya con Dios,
Chuck, CABGx3




"Vindell" wrote:

> I have to compare membership lists to identify if customers belong to certain
> groups. Currently, I have been using Vlookup but I notice that there are too
> many nuisances. Could I use a filter to compare two membership lists and give
> me a more accurate answer?