See Bosco's comment in #4. By changing the headers to text (ie using ">", "-", or "<" in the header) you stopped the Match function from operating. I'd recommend using 0, 5, 10, 15, 20, and 100 for the headers. The function works with that. If you must do the headers as you have them above, use a separate part of the spreadsheet to list the 0 to 100 values and reference that in your function. (See attached for example)
thank you for the assistance Mike86. I only put the greater than less than to show the ranges. My actual file does not have that. I will try your suggestions today and let you know if I was able to get it to work. My issue is the first column that shows 0. this column should actually be referenced only if the number is less than 0. a number between 0 and 5 should pick up the next column and so on.