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!