Using Excel 2007, Marking a cell if another cell contains data from a list

Using Excel 2007, Marking a cell if another cell contains data from a list

I am working on a spreadsheet and I need to have a way to mark items that
have been recently ordered. Each row is an item in inventory. I have a
separate list of item numbers that have been recently ordered and need a
function that will look to see if the item number for each row (column A)
is also present in my list (Column A on another sheet, "Recent POs") and
flag those rows accordingly, perhaps by returning a message such as
(recently ordered). I've tried a handful of things and am struggling. This
seems like it should be easy. Any thoughts? Thanks.