[Solved] Need Vlookup to return smallest value greater than or equal to search criterion

Example:

A1 = 26

A2 = 80

A3 = 95

B1 = 950

B2 = 1500

B3 = 1650

C1 = 99

C2 = 3

=VLOOKUP (C1/C2,A1:B3,2,1)

returns 950

I need it to return 1500. However, if C1=52 and C2=2, I need it to return 950.

I am not stuck on using VLOOKUP: I just need a formula that will work!

Hallo

=INDEX(B1:B3,MATCH(C1/C2, A1:A3)+1)

Hi! That seems to be a step in the correct direction, but it chooses the higher value even when C1/C2 = A1.

I ended up using:

=IF (ISNA (VLOOKUP (C1/C2,A1:B3,2,0)=1,INDEX(B1:B3,MATCH(C1/C2, A1:A3)+1),VLOOKUP (C1/C2,A1:B3,2,0))

Thanks for the help!

Hi!

=IF (ISNA (VLOOKUP (C1/C2,A1:B3,2,0)=1,INDEX(B1:B3,MATCH(C1/C2, A1:A3)+1),VLOOKUP (C1/C2,A1:B3,2,0))

seems to work. Thanks for the help!

Please mark correct answer with checkmark