Special lookup need
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Rajat" schrieb im Newsbeitrag
...

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