Looking up a price band?

Pinching Andy's solution to 99 % I've instead used the "Private Sub Worksheet_Change" command to fire the macro so as soon as a value is entered in cell G7 this will update the sheet.

Alf

Ps Any credit for solving this problem should be given to Andy!