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 ?