View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
just_jon
 
Posts: n/a
Default multiple column lookups

First, create a new column on Sheet2 in D, filling with:

=A2&CHAR(1)&B2

Copy down to end of data in A,

In Sheet1, D2 copied down:

=IF(COUNTIF(Sheet2!D:D,A2&CHAR(1)&B2),"Yes","No")

In Sheet1, E2 copied down:

=IF(D2="Yes",IF(INDEX(Sheet2!C:C,MATCH(A2&CHAR(1)& B2,Sheet2!D:D,0))=C2,"$OK","$No"),"")