Thanks:  0
Likes:  0

# Thread: VLOOKUP returning a BOOL

1. 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.

2. On 2002-04-12 03:32, KnAsTa wrote:
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. [img]/board/images/smiles/icon_smile.gif[/img]
Better use MATCH for that option like in:

=ISNUMBER(MATCH(E1,G1:G10,0))

3. hrm.........could you please elaborate on the MATCH statement, and ISNUMBER statement. I do not understand. Sorry

4. On 2002-04-12 03:53, KnAsTa wrote:
hrm.........could you please elaborate on the MATCH statement, and ISNUMBER statement. I do not understand. Sorry
MATCH returns a row or column number if it succeeds to find a value that matches its lookup value, otherwise #N/A.

=ISNUMBER(7) returns TRUE

=ISNUMBER(#N/A) returns FALSE.

5. thanks a lot, that really helped. Cheers

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•