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
How to use the values in 2 cells as the range in a lookup
-
-
-
From Range : Sheet1.Range("G1").Value
To Range : Shet1.Range("G2").Value