Ask Your Question

Not getting desired output [closed]

asked 2014-03-20 06:23:25 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have data in two file there are


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

In these two file I'm applying the following formula


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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:39:31.655902

1 Answer

Sort by » oldest newest most voted

answered 2014-03-20 07:20:41 +0100

Ram.BM gravatar image

updated 2014-03-20 07:21:09 +0100

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

edit flag offensive delete link more


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

mahfiaz gravatar imagemahfiaz ( 2014-03-20 13:41:36 +0100 )edit

Question Tools

1 follower


Asked: 2014-03-20 06:23:25 +0100

Seen: 97 times

Last updated: Mar 20 '14