L
laurafv
I need urgent help with this I've been trying to find a formula fo
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 fo
(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 followin
format:
argentina 1980 rating
argentina 1981 rating
argentina 1982 rating
argentina 2007 rating
....
zambia 1980
etc
zambia 2007
Thanks a lot!
Laura
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 fo
(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 followin
format:
argentina 1980 rating
argentina 1981 rating
argentina 1982 rating
argentina 2007 rating
....
zambia 1980
etc
zambia 2007
Thanks a lot!
Laura