IF VLOOKUP

[Micayla Bergen]

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

 

[Max]

Try this alternative:
=IF(ISNA(MATCH(A2,Rebooked!$A$1:$A$5413,0)),0,1)

 

[Biff]

Hi!

Try this:

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

Biff