Okay, you are the best. The last option worked out great for my needs. I am able to write the data in reverse order. The blank cells do need to be in there but I just spaced the data including those blank cells. The only small problem that I am having is that I understand your formula and I only needed one formula as far as I know to do this but I am having problems with adding to the formula to cover the various columns I need.
=IF(AND($B$1>=4,$B$1<=4.03),(INDEX($GB$3:$GB$37,MATCH(C3,$J$3:$J$37,1),(IF(AND($B$1>=4.04,$B$1<=4.07),(INDEX($GB$3:$GB$37,MATCH(C3,$P$3:$P$37,1))))))))
This is the example of the formula that I wrote but I am getting a "False" response when I enter data for lets say B1 equalling 4.05 but it works for for b1 equal to 4 to 4.03. What am I missing?
Thank you again, I am so excited to complete this project!!!
I can see two basic things wrong with your formula:
1. You have two too many ')' at the end of your formula and two too few in the middle. Remove two from the end and place where I have the red ones and try that.
=IF(AND($B$1>=4,$B$1<=4.03),(INDEX($GB$3:$GB$37,MATCH(C3,$J$3:$J$37,1)
)),(IF(AND($B$1>=4.04,$B$1<=4.07),(INDEX($GB$3:$GB$37,MATCH(C3,$P$3:$P$37,1))))))
2. Your second IF has no 'False' argument. In other words, if ...
IF(AND($B$1>=4,$B$1<=4.03)
and IF(AND($B$1>=4.04,$B$1<=4.07) are
both false, your formula does not say what to do.
Now, there may be other things wrong and/or there may be another way to write the formula, but without seeing some sample data it is hard to know.
If you do have further problems, see if you can construct a smaller data set to demonstrate the problem and post your data and explain the problem in relation to that data. I suspect you found it easier to understand what I was getting at in my previous post because you could see what layout I had, what my data was and what my results were. The same applies to me.
