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
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
From Range : Sheet1.Range("G1").Value
To Range : Shet1.Range("G2").Value