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

(for lists of data not in order)


--
HTH
Roger
Shaftesbury (UK)


"wiwi" wrote in message
...
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...


---
Message posted from http://www.ExcelForum.com/