IF Lookup match combined function?

[paulpfl]

Hi! I have a list of account numbers, if they match the list of $0 admin fee list on another sheet, I would like it to equal 0 but if not, 10. I have =IF(B2='$0 admin sheet'!$A$1:$A$1783,0,10).

Thank you in advanced!!!!

 

[Scott T]

Try

=IF(ISNUMBER(MATCH(B2,'$0 admin sheet'!$A$1:$A$1783,0)),0,10)

 

[paulpfl]

THANK YOU SO MUCH, holy **** you just made my day