If formula to match a list of numbers to another list

Hello,

I have a spreadsheet.

column A is ACCOUNT NUMBERS ie; 3TEST, 3 GERRY , 1CART

Columns B to G are the tradlists for these customers ie, B1 = 406, C1 = 23.

tradelist values are 0 upto 999.

I need to identify which accounts have a certain tradelist in any of these 6 columns, and replace them with a 0

the tradelists I need to identify are:

407
408
409
410
411
412
413
414
415
416
425
426
434
435
436
437
438
439
440
442
443
445
446
447

I have done a formula in column H, which is

=IF(B2=407,"YES",IF(C2=407,"YES",IF(D2=407,"YES",IF(E2=407,"YES",IF(F2=407,"YES",IF(G2=407,"YES","NO))))))

which is fine to identify 1 number...

Can anyone suggest a way of identifying customers who have ANY of the tradelists in the 6 columns?

I was thinking along the lines of =IF(B2=407:447 etc.... and doing a range, but the numbers I need to find are not consistent....

Is there away of searching for multiple numbers with an IF statement?


I eargly await your replies :D


Thanks.