Hi Alex

not sure what you mean by column A = A1
do you mean every value in column A being the same as the value in A1?

Cheers
JulieD


"ALex" wrote:

How would one include the following conditions in a folmula

IF Column A= A1 and Column B =B1 then C1=1
IF Column A= A2 and Column B =B1 then C1=2

IF Column A= A1 and Column B =B2 then C1=4
IF Column A= A1 and Column B =B3 then C1=5

etc...