Vlookup Errors

Hi! Experts

I have a table
for eg See the Attached

In Sheet " Master" column A contains CustCode. In Sheet" Vlookup" Column A contains another CustCode.
when i give a vlookup in a different sheet to check for PropNo. in column B . The first cell works fine, but for the second cell it returns the Same value

Is there a way to get round this

Thanks in advance

Hardeep Kanwar