Special lookup need

[Rajat]

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

 

[Frank Kabel]

Hi
e.g. in C1:
=INDEX(A2:A100,MATCH(B1+1,B2:B100,0))