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/