Hi All, Im sure this isnt all that tough- but im stumped.
I have attached a workbook. Basically, what I need to do is populate the column "assumed value". In order to do this, I created three tables at the far right of the worksheet. I labeled the vehicles model and year, and then placed values based on mileage assumptions. I used broad groupings because i couldnt figure out any easier way (figured 10k miles per year). What i'd like to do is have the workbook recognize the model, year and assumed mileage (highlighted the columns yellow- H is what I need, I, J, K is the data im using) and produce an assumed value based on this. Any help would be greatly appreciated. Thanks in advance!
Bookmarks