How do I find another EXCEL whether the need to include data

I have two forms, 2 forms of data are extracted from a table, now in the form of an extract from these data to find out and tag, how do we go?

re-find it again, the original data into a format such as red.Form 2 is not extracted this information?
directly will be able to form a 2.
there, you can look back operation ah.From Table 2, once again chant.assumption that the data are presented in table 2 of Table A as a sign of the extract is
in Table 1, after the A list , To insert a supplementary list B out, B1 enter the formula
= if (countif (Table 2! A:A, A1), “Table 2 has been extracted “,””)
B1 to copy the formula down
At this time, data was extracted are listed in the B mark out the