vlookup problem

[wiwi]

in worksheets (Order Confirmation)
Range J4 = Buyer (using data validation =Buyer )
Range J5 = vlookup(j4,Agent,1)

in workheets (AgentBuyer)
Name for Column B is Buyer and for column A is Agent

my vlookup is not working properly after I add new record on
AgentBuyer
please help and advice...

 

[Roger Whitehead]

Try
Range J5 = vlookup(j4,Agent,1, False)

(for lists of data not in order)