Vlookup information in a table and Round up(file attached)

I am trying to automaticaly round an uneven number to up to predefined numbers in a table on a different tab.

The file is color coded on what cells i want to do what.....Start with the red cell

This i more than likely very easy but i have been beating my head agenst the wall in the help menue.

If someone could help me create the first one i would be able to teach myself the rest.

Thanks for your help

Nick

This should do it:

Please Login or Register  to view this content.

This works perfectly!

Can you take a second and quickly explain how and what all of this stuff is doing?

INSA, the 15 in the middle of the statement,the +1 at the end of the statement?

Sorry for being so clueless, i just want to be able to do this again!

Nick

If the value being looked up, is less than the lowest value in the table, the MATCH function returns an #N/A. The IF(ISNA(MATCH()), 15 ,INDEX( MATCH()+1) is saying that if the result of the MATCH is N/A, return 15, or you could use a link to the cell itself in case 15 isn't always the lowest value. INDEX(MATCH()+1) - since the MATCH function returns either an exact match or the lowest previous value, the INDEX portion would be showing that value. I had to bump up the row by one to "round up" to the next value. I just realized you wil get an incoorect value if your lookup value mactches one of the vaules in the table.

This formula eliminates that error

Please Login or Register  to view this content.