Need help getting correct answer for the following-
I have three columns of data:
Column A shows several answers, multiple times
Column B shows ascending numbers for each of the different answers in Column A
Column C is the data I wish to return.
I wish to get the correct answer from Column C (or the answer that is less than the match), corresponding to the correct part of column B as identified by column A.
Example attached should make this clearer.
I have tried all forms of index, match and if statements, but this is beyond me as keeps throwing up the wrong answer. I can set the data table up differently if this would help.
Appreciate anyone's help with this.
thanks
Bookmarks