excel formula not working

Good evening,

I'm hoping someone could please help me fix my formula?

The spreadsheet has 2 tabs. 1 tab is an order number (sheet 2) and the other tab is a table.  The table contains the order number (please note the order number can be repeated a number of times since it has different items on it) and then it column c it may have a date in it.  I have used the following if formula =IF(A2=table!$A$2:$A$1803,table!$C$2:$C$1803,false) asking it to return the picking date for that order number.  It keeps bringing up False.  Any idea what I need to amend to make it produce the picking date if there is one?  Many thanks