Hello,

I need a function that does the following:

1. read the value in the column to its left (say, "5")
2. add one to that value (5 + 1 = "6")
3. look down that column to find the first instance of "6"
4. return the value in the column to the left of the "6"

Is there a worksheet function to do this or would I need
to write my own function in VBA?

If so, please suggest how I would write this function?

Thanks,

Rajat