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

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

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

"Miguel Zapico" wrote:

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

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.
--
"nick" wrote:

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

"Miguel Zapico" wrote:

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