View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erwin[_3_] Erwin[_3_] is offline
external usenet poster
 
Posts: 1
Default 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.