Formula Stumped

[NSchipper]

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!

[MrShorty]

Seems like it should be a basic lookup function: https://support.office.com/en-us/art...__toc309306714

Where you want the "just larger" value, rather than the "just smaller" value, I would use the MATCH() function for the lookup, followed by the INDEX() function to return the desired value.

If you are allowed to sort the data in descending order, then this will be striaghtforward with -1 as the MATCH() functions third argument. =MATCH(lookup value,lookup column,-1)

If you are not allowed to sort the data in descending order (naturally assuming the data will be sorted in ascending order), then you use +1 for the third argument, then add one to the result of the MATCH() function (=MATCH(lookup value,lookup column,1)+1)

[MrShorty]

duplicate post with sample file
http://www.excelforum.com/excel-form...e-formula.html