Give results if a value in a column matches

Hello,
I would like Column L on sheet 1 to display the data in Column O on sheet 3 if the data in column A on sheet 1 matches the data in column c in sheet 3. For example, both sheet 1 and sheet 3 display 5 digit numbers that match but are in different order, and on sheet 3 in the same row as the 5 didgit number is text that I would like to display on sheet 1.

Sheet 1 Sheet 3
Column A Column L Column C Column O
(Cell 1) 58463 ? (Cell 1) 14875 YES
(Cell 2) 74852 ? (Cell 2) 58463 NO
(Cell 3) 14875 ? (Cell 3) 74852 YES

Since in Sheet 1 Column A Cell 1 the number matches Sheet 3 Column C Cell 2 I want Column L Cell 1 in sheet 1 to Display "NO" .

Thank you.