You can create a list (named list_values, for example) with all that numbers,
and use a formula like this in A1 of worksheet2:
IF(ISNA(MATCH(worksheet1!A1,list_values,0),"",IF(A ND(worksheet1!A1="003",year_cell=1999),worksheet1! B1,"")))
--
It is nice to be important, but it is more important to be nice


"nick" wrote:

Hi,

If A1 from worksheet1 is equal to any of these "002,018,021,026,050,
051,054,055,059,082, 085,086,089" and "003 if in year 1999" then A1 in
worksheet2 should be populated with the value of B1 from worksheet 1. How do
i do this? ANy help??? Thanks