Multiple Lookups Problem

[sopmac]

I am having problems with queries. I am trying to create a query that that refers to main data and then looks in a table for a specific figure. My table has fields for "symbol" and then several fields for "years" (2002, 2001, 2000,...). What I want to do with this table is lookup the "symbol" field with my main data table's "symbol" field and then if this symbol matches, I want to retrieve the figure from the "years" field that corresponds with a "year" field in my main data table. I am not sure what to use: nested iifs? dlookup? choose? switch? other? Any help will be greatly appreciated.

Thanks.
Ivan