Good Afternoon,
I'm attempting to match a list of values to a corresponding set of values that are delimited by range. Here is the current set-up of my information
Min Months Max Months Factor
0 6 2.1
7 12 1.9
13 18 1.68
19 24 1.59
25 30 1.45
The ranges are bound by the values in the first two columns. I have a corresponding list of integers that I would like to match to the factors listed in the 3rd column by determining which range above the value falls in.
It's hard to say without knowing what the corresponding list looks like, but if I were to take a wild guess
=vlookup(c1,g1:j100,3,0)
where g1:j100 is the corresponding list
c1 is the factor
and you need the third column
Need more data for a more accurate answer, can you attach a De-sensitized sheet?
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Hi,
Something like this?
I've attached an example.
I'd like to match the factors in the "Factor" column to the values in Column A, based on which range the values in Column A fall into, where the ranges are denoted by the numbers in the Min and Max Months Since columns
So the numbers in column A are months or Factors?
See if this is what you are looking for (file attached).
The numbers in column A are months, sorry for not clarifying that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks