Vlookup Help Master list
Trying to make multiple lists based on the first character of a master list onto seperate sheets. I.E. I have a master list in sheet 1. I would like to make a list for each letter A-Z on corresponding sheets. I have 4500 items in the master list. Cannot figure out how to use the Vlookup and Left function together as well as returning multiple items between seperate sheets. Thank for all the help in advance!
In think this thread below is pretty much exactly the same request... and has a suggested working solution....See if it works for you.
http://www.excelforum.com/excel-prog...-criteria.html
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks