I've been fighting with this all day. What I am trying to do is to get a drop down that when one of the options is selected it populated 2 other values into 2 other cells. Lets say I have a drop down of cars. GMC Envoy, Toyota Highlander, Hummer H2. I want the user of the spreadsheet to be able to select GMC Envoy and have the MSRP populate in one cell and the Invoice price populate in another cell. I cannot figure this out for the life of me and any help would be appreciated. Thanks