Is there an operator to look for any number in a range?

Accounting has added several account numbers to my list and I need to modify one of my formulas to get information from any of those accounts. The formula I have been using is:

Please Login or Register  to view this content.

Now I am responsible for accounts 26500, 26501, 26502, 26503, 26504 and 26505. Is there a way to modify the formula to look for that range instead of just one at a time?

If those are the only account numbers beginning with 265 you could use

=SUMPRODUCT((LEFT('J V'!$B$4:$B$26,3)="265")*('J V'!$A$4:$A$26=Transfer!A2),'J V'!$C$4:$C$26)

or perhaps

=SUMPRODUCT(('J V'!$B$4:$B$26>=26500)*('J V'!$B$4:$B$26<=26505)*('J V'!$A$4:$A$26=Transfer!A2),'J V'!$C$4:$C$26)