I need urgent help with this ;) I've been trying to find a formula for
hours with no luck!!

I need to perform lookup using two rows as a criteria...


I have two problems:


Problem 1.- I have a file containing the data I want to lookup for
(i.e. ratings):

philippines
2007 rating 1
2005 rating 2
2000 rating 3
1989 rating 4
...


brazil
2000 rating 5
1995 rating 6

usa
1970 rating 7
1985 rating 8

etc
(180 countries)

and i have to copy the ratings in a file that looks like this:

argentina 1980 rating
argentina 1981 rating
argentina 1982 rating
(...)
argentina 2007 rating
(...)
zambia 1980
(...)
zambia 2007

(180 countries)

any ideas on how to solve this?

Problem 2 .- I have other ratings in the following format:

country 1 year 1 rating 1
country 1 year 2 rating2
etc

that need to be looked up and imported in a sheet in the following
format:

argentina 1980 rating
argentina 1981 rating
argentina 1982 rating
argentina 2007 rating
....
zambia 1980
etc
zambia 2007

Thanks a lot!


Laura.




--
laurafv