Comparing / Finding text in Lists

[ajohns]

Hi

If I have three main columns of text values (i) Company ID (ii) Well ID
and (iii) plate ID and say I want to select 153 out 332 wells using
another (smaller) list how would I do this in Excel?

Many thanks

Yours

Andrew J
Scotland

 

[BrianB]

Without seeing your data I guess one way would be to use another colum
in your main list with =VLOOKUP() formula into your small list and the
filter or sort on this column.

A formula like :-
=IF(ISERROR(VLOOKUP(A1,Sheet2!$A$1:$D$38,2,FALSE)),0,1)
will put a 1 if found or 0 if not

 

[Andy B]

Hi

Have a look at Chip's site:

http://www.cpearson.com/excel/duplicat.htm

Andy.