Not getting desired output

[Ram.BM]

I have data in two file there are

file1: https://app.box.com/s/vhspjgex5op42irdmpa4

file1: Box (download the these two files by using download option)

In these two file I’m applying the following formula

=IF(ISNA(VLOOKUP($A2;$B$2:$B$5;1;0));"";VLOOKUP($A2;$B$2:$B$5;1;0)) 

but sampl2.ods is showing proper result but sample1.ods is not showing proper result . Why these two files behaving like this please tell me

[Ram.BM]

inted of =IF(ISNA(VLOOKUP($A2;$B$2:$B$5;1;0));"";VLOOKUP($A2;$B$2:$B$5;1;0)) we can place =IF(ISNA(VLOOKUP($A2;$B$2:$B$16075;1;0));"";VLOOKUP($A2;$B$2:$B$16075;1;0)). Then it works fine

[mahfiaz]

Also take a look at IFERROR() function, makes everything nicer except compatibility with Excel and Google Docs.