on a VLOOKUP I need a formula to return a value of 1 if FALSE, and a 0 instead of NA
on a VLOOKUP I need a formula to return a value of 1 if FALSE, and a 0 instead of NA
you could use a countif() rather than a vlookup
however
IF( ISERROR ( VLOOKUP(..... what ever your formula is ......... ) , 1 , 0 )
if that does not match a lookup - ie returns and error - then you have TRUE and so returns a 1
OR
=IF( countif( column you are trying to match , value to match )=0 , 1 , 0 )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
can you provide an example of the formula you are using? i'm not sure what you mean by "1 if FALSE".
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
I don't have a formula. I want to return the number one if there is a match and a number zero if there is no match on a vlookup
what do you have forI don't have a formula.
which is your formula ?vlookup
I would use a MATCH formula for this instead of a VLOOKUP
=IF(ISNA(MATCH(A1,B1:B100,0)),0,1)
Where A1 is the value you are looking for, and B1:B100 is the range you are looking for it in.
Or maybe something like this?Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks