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

3butts · Jun 24th 2019

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

Logit · Jun 24th 2019

From Range : Sheet1.Range("G1").Value
To Range : Shet1.Range("G2").Value

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

Participate now!

Share