I have two questions here.
1. [SOLVED] In the attached spreadsheet example, I have a data validation in Sheet1 Column A that pulls from a Cost Code Description list on Sheet2, then Column B uses XLookup to populate data. Rather than selecting from a drop-down list like I currently have, is there any way that I can start typing and excel predicts what I am trying to type based on the list? That way if I do not remember exact description I can still find it quickly. Ideally, it would still have a dropdown list that gets smaller as I type in more letter (narrow the search parameters.)
EDIT: I found an add-in that does basically what I wanted. PM me if you are interested.
2. [SOLVED maybe]Sheet2 in the example is part of a greater Master list that resides in another workbook. If I am going to be using Vlookup or Xlookup based on the master list, would it work to better to eliminate sheet 2 and reference the master workbook directly, or keep sheet2 and have it sync with the master list whenever I open this workbook. Whichever is the preferred method, how would I best accomplish it?
EDIT: I ended up using 'Get Data" to bring in the Master list on its own worksheet and set it to auto update upon opening. If there is a better way, or pitfalls associated with this, I'd appreciate any advice.
Thanks for any help!
Bookmarks