Hi, I need some guidance regarding a formula. Not knowing if a formula or macro is better I posted here.

I have a cell where the user can enter a quantity (example $1000). I want the formula of another cell to read a quantity from a table (rounded up) when this is entered.

For example, User enters quantity $1000 into Cell A1.
Cell A2 reads this amount ($1000) and rounds UP to the nearest total to that amount on a data set (if the table has no cell for $1000 it reads the data under the column for $1250)
Cell A2 shows the value from the data set under that column.

I can get more specific if needed to reach out to me and let me know!