I have a formula
=IF(ISERROR(VLOOKUP(A1,region,2)), "Unknown", VLOOKUP(A1,region,2))
Value of A1 is 'REPOFSERBIA'

Output of the formula gives me 'Northern Europe' instaed of 'Southern
Europe' . Looks like Country 'Qatar' is causing problem.
What's the problem with formula ?

Region is defined as
Country
Region

REPOFSERBIA
Southern Europe

ALGERIA
Africa

ARGENTINA
Latin America

AUSTRALIA
Pacific

AUSTRIA
Northern Europe

BANGLADESH
Northern Europe

BELGIUM
Southern Europe

BRAZIL
Latin America

CANADA
Canada

CHINA
FarEast

COLOMBIA
Latin America

COSTA RICA
Latin America

CZECH REPUBLIC
Northern Europe

DENMARK
Northern Europe

EGYPT
Africa

ENGLAND
Northern Europe

FINLAND
Northern Europe

FRANCE
Southern Europe

GERMANY
Northern Europe

GREECE
Southern Europe

GUATEMALA
Latin America

HONG KONG
FarEast

INDIA
Northern Europe

INDONESIA
FarEast

IRELAND
Northern Europe

ISRAEL
Northern Europe

ITALY
Southern Europe

JAPAN
FarEast

JORDAN
Northern Europe

KOREA
FarEast

KUWAIT
Northern Europe

MALTA
Southern Europe

MEXICO
Latin America

MEXICO
Latin America

MICRONESIA
Pacific

NETHERLANDS
Northern Europe

NEW ZEALAND
Pacific

NIGERIA
Africa

NORWAY
Northern Europe

OMAN
Northern Europe

PAKISTAN
Northern Europe

PANAMA
Latin America

PHILIPPINES
Northern Europe

POLAND
Northern Europe

PORTUGAL
Southern Europe

PUERTO RICO
Latin America

QATAR
Northern Europe

ROMANIA
Northern Europe

Russia
Southern Europe

SAUDI ARABIA
Asia

SINGAPORE
FarEast

SLOVENIA
Northern Europe

SOUTH AFRICA
Africa

SPAIN
Southern Europe

Sri Lanka
Asia

SWEDEN
Northern Europe

SWITZERLAND
Northern Europe

SYRIA
Asia

TAIWAN
FarEast

THAILAND
FarEast

THE NETHERLANDS
Northern Europe

TRINIDAD
Latin America

TURKEY
Asia

UNITED ARAB EMI
Asia

United Kingdom
Northern Europe

United States
Local

USA
Local

VENEZUELA
Latin America

VIRGIN ISLANDS
Latin America

YUGOSLAVIA
Northern Europe

You're probably trying to do an EXACT lookup..
in which case you need to set the 4th argument of the VLOOKUP function to
0 or false... you've left it out and then it defaults to true...



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Shashi Bhosale" wrote:


I have a formula
=IF(ISERROR(VLOOKUP(A1,region,2)), "Unknown", VLOOKUP(A1,region,2))
Value of A1 is 'REPOFSERBIA'

Output of the formula gives me 'Northern Europe' instaed of 'Southern
Europe' . Looks like Country 'Qatar' is causing problem.
What's the problem with formula ?