Here's an example of what I'm working on
A1 B1 D1 E1 F1
Year Car Model Used New Mileage
2000 Toyota Highlander 15 27 20,500
2001 Kia Optima 8 16 15,400
2002 Dodge Charger 18 31 0
etc



im looking for a formula for D1,E1,F1,etc, so that when i type the specific year and car model in A1 and B1 , it brings back the row of data that i have on another worksheet. the data changes for each model by year, and i have 16 different tables of data (one table for each year 2000-2015). i have been manually typing in the data for each year but i figured their was an easier way. I was thinking it was a reference formula question. any and all help is much appreciated. thanks in advance.