VLOOKUP - round up to next number

[DashboardNovice]

Column I shows the results I am trying to get.

My formula is in column G. I am doing a VLOOKUP with column F as the lookup value. I want to look in column O. If the lookup value is not found in column O, VLOOKUP returns the first number below the lookup value, but I would like for VLOOKUP to return the first number greater than the lookup value.

For example, in G19, I am using 46 as the lookup value, but it's not found in column O, so VLOOKUP returns 44, but I would like to return 49 in this example.

 

[AliGW]

Try this:

=IFNA(VLOOKUP(F6,$O$6:$O$17,1,0),LOOKUP(F6,$O$6:$O$17,$O$7:$O$18))

 

[AliGW]

Or this:

=IFNA(IFNA(VLOOKUP(F6,$O$6:$O$17,1,0),LOOKUP(F6,$O$6:$O$17,$O$7:$O$18)),$O$6)

 

[AliGW]

Any use at all???

 

[AliGW]

You've started another thread and not even acknowledged the help I offered here. Some feedback for the effort I made on your behalf would have been courteous.

 

[AliGW]

Still no response. Why???

 

[DashboardNovice]

Try this:

=IFNA(VLOOKUP(F6,$O$6:$O$17,1,0),LOOKUP(F6,$O$6:$O$17,$O$7:$O$18))

Sorry I didn't reply earlier. This was what I was looking for. Thank you.