Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List Comparison | Excel Discussion (Misc queries) | |||
List Comparison | Excel Discussion (Misc queries) | |||
strange problem displaying array in list box | Excel Programming | |||
Randomized Paired Comparison Array | Excel Programming | |||
list comparison | Excel Worksheet Functions |