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)