Help with IF Conditions

[Guest]

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

 

[Guest]

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(AND(worksheet1!A1="003",year_cell=1999),worksheet1!B1,"")))

 

[Guest]

Is there any way to do this without ceating a different worksheet? Please
advise Thanx

 

[Guest]

You don't need to create a new worksheet, you can place the list on a hidden
column of an existing worksheet.
I cannot think of an easy option without rewriting in some place the
information to be compared, sorry.
--