IF VLOOKUP
 

i am using this formula to find if the vaue is on another spreadsheet. the
true value returns 1 so i can add up the number but the false returns #N/A
which then stops the sum function from working. and the 0 or "0" false value
doesnt seem to work.

=IF((VLOOKUP(A2,Rebooked!$A$1:$A$5413,1,FALSE)),1, "0")

thanks

IF VLOOKUP
 

Try this alternative:
=IF(ISNA(MATCH(A2,Rebooked!$A$1:$A$5413,0)),0,1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Micayla Bergen" wrote in message
...
i am using this formula to find if the vaue is on another spreadsheet. the
true value returns 1 so i can add up the number but the false returns #N/A
which then stops the sum function from working. and the 0 or "0" false
value
doesnt seem to work.

=IF((VLOOKUP(A2,Rebooked!$A$1:$A$5413,1,FALSE)),1, "0")

thanks

IF VLOOKUP
 

Hi!

Try this:

=(COUNTIF(Rebooked!$A$1:$A$5413,A2)0)*1

Biff

"Micayla Bergen" wrote in message
...
i am using this formula to find if the vaue is on another spreadsheet. the
true value returns 1 so i can add up the number but the false returns #N/A
which then stops the sum function from working. and the 0 or "0" false
value
doesnt seem to work.

=IF((VLOOKUP(A2,Rebooked!$A$1:$A$5413,1,FALSE)),1, "0")

thanks