is it possible for VLOOKUP to return a boolean value, say:
IF the value exists in the column you are "VLlooking up" then it will return true. This would then aid in using it within an IF statement. So Iff value exists, then do this, if it doesnt, then do something else....
this is my code so far
=VLOOKUP(A5,week1.xls!$A$1:$A$10,1,0)
any help would be much appreciated. Thanx a lot.
IF the value exists in the column you are "VLlooking up" then it will return true. This would then aid in using it within an IF statement. So Iff value exists, then do this, if it doesnt, then do something else....
this is my code so far
=VLOOKUP(A5,week1.xls!$A$1:$A$10,1,0)
any help would be much appreciated. Thanx a lot.