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
|