How to use the values in 2 cells as the range in a lookup

  • Hi. Is it possible to use the value in cell G1 as the start of a lookup range and the value in cell G2 as the end of the lookup range? I have set the values in cells G1 and G2 to change depending what team is selected. Many thanks, Pete