display all rows when condition is true

[lemuel]

I have two main data sources, and i want to get the data from website tab that are not esp tab.
And the results should display on tab Sheet1 and Sheet2

please check attached xls. and advise to generate code for it.

[ChemistB]

First I made a key on Sheet1. You can hide this row if you like. It separates those on both website and esp ("WNE") and those only on Website ("WO") and numbers them starting at 0. The formula in Sheet1!A7 copied down is

=IF(ROW(A1)>COUNTA(website!C:C)-1,"",IF(ISNUMBER(MATCH(website!C2,esp!$B$2:$B$11,0)),"WNE_" &COUNTIF($A$6:A6,"WNE*"),"WO_"&COUNTIF($A$6:A6,"WO*")))

Then on Sheet1 in B7 dragged across and down
=IFERROR(INDEX(website!A$2:A$11,MATCH("WO_"&ROW(A1)-1, $A$7:$A$16,0)),"")

I did something similar on sheet2 except I referenced the key on sheet1 since it was already there
=IFERROR(INDEX(website!B$2:B$11,MATCH("WNE_"&ROW(A1)-1, Sheet1!$A$7:$A$16,0)),"")

See attachment
Does that work for you?