Look up 'X' in a table of value ranges & return the correct answer

[Tamarissa]

Hi there,

I have a file where in cell B6, I need to look up the value in A6, and return the correct value in column G, based on where A6 falls into the correct range of values (greater than the value in column E, but less than the value in column F)

Thanks so much for any thoughts 

[TheExcelphile]

Hi Tamarissa!

Enter the following formula in B6, and autofill:

=INDEX($G$5:$G$47,MATCH(A6,$E$5:$E$47,1))

Don't forget to click the little star to the left of this post if you feel I helped!