vlookup problem

  • Thread starter Thread starter wiwi
  • Start date Start date
W

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...
 
Try
Range J5 = vlookup(j4,Agent,1, False)

(for lists of data not in order)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup - how to put this into VBA 2
Named Range 5
Help in printing a sorted list of customers purchases 3
VBA userform Vlookup Excel 1
Help with If / Loop / Adding cells 1
Excel 2 into 1 6
Using range names in SQL query 3
Filter Data based on criteria 3

Back
Top