I am trying to enter a formula to bring back data based on a certain number. The number may be a whole number or not, like 1 or 1.31, but I need it to tell me what is in Column B if that number is in the range in column A. Like:
Column A Column B
0-4 15
5-9 20
Any help is MUCH appreciated!!
Bookmarks