hello, in the attached sheet I would like to be able to select a specific car from the drop down list in "sheet 1" and have that selection cause the scoring for that car in the "scoring library" tab be populated under the drop down menu. I have seen examples using an if statement with a vlookup function in it but this only seems to work for horizontal data. Thanks in advance.EXCEL FORUM EXAMPLE.xlsxAttachment 193417