Excel 2007 : IF function

OK,
Here's a sort of crude solution, but it's simle and it works.
See the atccahed file.
On List1, I've created a column A and on List2 I added column R.
You can hide both of these columns.
Now look at the formula in C21 on List2 sheet.
You can drag that formula up and down that column.
Also, drag formula in col. A[List1] and R[List2].
Hope it works for you.

You can try it out by entering different values in E21 thru' H21 on List2 and see C21 give you the right answer.
modytrane.

Ok so it is posible and works so tnx.
I'm still trying to make something witouth help cells hehe. but ill use this now
It realy helps a lot ty.