Vlookup function
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. |
Vlookup function
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. |
All times are GMT +1. The time now is 05:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com