Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Access data in Excel | Excel Worksheet Functions | |||
Lookup Problem | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |