Need help on the following :

I have a list of countries which is separated into Group A, B and C. Each of
these countries return to a value based on certain conditions e.g

Conditions | Country Group A | Country Group B | Country Group C
Heavy | 1 | 2 |
3
Medium | 2 | 3 |
4
Light | 3 | 4 |
5

I have set up a vlookup function for this. However, there is an exception,
China which falls under Group B should return 4 for all conditions. India
which is in Group C should return 5 for all conditions.

What formula can I use? Thank you.

Hi,
I assume the country is in column A starting in row 1 change it to fit your
needs

=if(A1="China",4,if(A1="India",5,your formula))

"Karen" wrote:

Need help on the following :

I have a list of countries which is separated into Group A, B and C. Each of
these countries return to a value based on certain conditions e.g

Conditions | Country Group A | Country Group B | Country Group C
Heavy | 1 | 2 |
3
Medium | 2 | 3 |
4
Light | 3 | 4 |
5

I have set up a vlookup function for this. However, there is an exception,
China which falls under Group B should return 4 for all conditions. India
which is in Group C should return 5 for all conditions.

What formula can I use? Thank you.