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?
Technology Tips and News
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?
Does this do what you want?
=B3=VLOOKUP(A3,'Dec 2014'!A:H,2,FALSE)
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")
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"))