Comparing / Finding text in Lists

  • Thread starter Thread starter ajohns
  • Start date Start date
A

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
 
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
 
Back
Top