Not equal to in with vlookup

I am using a Vlookup formula to return some values

=VLOOKUP(A3,'Dec 2014'!A:H,2,FALSE)

I want that Returned value if not equal to  colomun B should give me false or other some other comment to tell its not equal

any Idea how?

April 6th, 2015 11:16am

Does this do what you want?

=B3=VLOOKUP(A3,'Dec 2014'!A:H,2,FALSE)

Free Windows Admin Tool Kit Click here and download it now
April 6th, 2015 12:12pm

I got that one 

Now What I want is 

If formula Returns #NA = New Entry

If <>B2 Returns= Changed

IF =B2 returns= No change

=IFISNA(B2<> VLOOKUP(A2,'Dec 2014'!A:H,2,False),"New Entry", =(b2<>(VLOOKUP(A2,'Dec 2014'!A:H,2,FALSE),"Changed","No Change")

April 6th, 2015 12:55pm

Try

=IF(ISNA(VLOOKUP(A2,'Dec 2014'!A:H,2,FALSE)),"NewEntry",IF(B2=VLOOKUP(A2,'Dec 2014'!A:H,2,FALSE),"No change","Changed"))

Free Windows Admin Tool Kit Click here and download it now
April 6th, 2015 2:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics