Excel Reference Formula Help

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.

Hey FDIB, i was reading up on INDEX MATCH while waiting for responses, and i think that's what i need, however i'm having trouble understanding the formula you suggested..all im getting is an error message when i use it.