Ok you are right. I want to return a number in call A1 if cell B10, and keep
the same conditional formula for A2 but this time A2 will equal A1+1 and so
on. I hope that this clarifies it.

"Toppers" wrote:

An example would help to clarify what you mean by "certain conditions" and
numbers being consecutive.

"Welby" wrote:

Hi,
I am working in excel 2007. I want to know how to get Column A to return a
reference number if Column B has certain conditions. P.S. the numbers in
column A has to be consecutive (Let's say, 3001, 3002, 3003, 3004)