Vlookup stops working after several rows

[nmbell]

Good morning. On the attached workbook, I have a vlookup on the second tab (Tab 2) that is meant to use the PO number entered in Column C to reference back to the matching PO number on Tab 1 (ODP Listing) to identify the vendor and enter the vendor name in Column C of Tab 2. The vlookup is working for the first four rows and then on the following three, it is not. ON the last three that are incorrect, it is pulling vendor names from different POs that do not align with the PO numbers. The formula I am using is as follows: =IF(C2=0," ",VLOOKUP(C2,'ODP LISTING'!B$4:C$29,2)).

Does anyone know what might be happening that the vlookup is working then all the sudden stops working? Any insight or help is greatly appreciated!!

[JohnTopley]

Please see yellow banner on how to attach a sample workbook as we cannot help without seeing the data.

[nmbell]

Sorry! I thought I had uploaded it correctly.

[wyowhite]

Need to look for exact match range =false.
=IF(C2=0," ",VLOOKUP(C2,'ODP LISTING'!B$4:C$29,2,0)).