ajfries Posted December 4, 2015 Share Posted December 4, 2015 I'm trying to create an invoice where I can use a drop down menu to select a customer (which I've accomplished), but then I want it to autopopulate with the customer's address from another sheet. I'm trying to use the VLOOKUP function but I just can't get it to work. I've been trying to get this to work for...a long time. Much too long. Is there anyone that would be willing to look at my file and help me out? I'm willing to pay at this point. :D Quote Link to comment Share on other sites More sharing options...
Wheres Toto Posted December 5, 2015 Share Posted December 5, 2015 I'm not sure I completely understand but can you do an IF statement - IF <this customer is selected> then <this address> is entered? Quote Link to comment Share on other sites More sharing options...
mom2hunangirls Posted December 5, 2015 Share Posted December 5, 2015 VLOOKUP is what I would have said. Do you have the name in one column and the address in another? (On the other sheet) And does the name appear exactly as on the invoice? What results are you getting? Quote Link to comment Share on other sites More sharing options...
Tsuga Posted December 5, 2015 Share Posted December 5, 2015 Hard to say without a reproducible example. For stuff like this I usually go to Stack Exchange: http://stackoverflow.com/questions/27702303/vlookup-not-working-with-text-search They will help you for free. ;) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.