I want to compare data on one sheet with data on another sheet (within the
same file) and then populate cells with data from that other sheet. For
example:

Column B (Sheet 1) has data that may have duplicate data from Column A
(Sheet 2). If so, I want to copy the data from Column B (Sheet 2) to Column
E (Sheet 1).

Can someone help me figure out which function(s) to use and how to formulate
the logical sequence?

Thanks!