Array problem? List comparison?
Hey,
Let me set up what I'm trying to do. I have 3 columns with the
following data.
A: 10, 20, 30
B: X, Y, Z
C: 28, 8, 1
Now, I have a last column, D, which I'm trying to figure out the
correct formula for.
I want D to return the following:
Look at column A, find the smallest number that's greater than the
adjacent cell in column C, and then return the adjacent cell in column
B.
|