Cannot select cell with formula

Are you asking to have the VBA Match on this value and then select that cell ADDRESS?

If so, a combination of Cells and Worksheetfunction.Match should do it. If you share your current code in a sample workbook with mock data, one of us will gladly assist.

Please take an attempt at doing this so that I or someone here can guide you where it is not working IF you don't get it by yourself!

Good Luck!

Well to start off your data is in the incorrect order to utilize "MATCH" as finding a value where it is greater than or Exact requires a Descending order.

So I will not go down that path unless you wish to reorganize your data!

I would probably do something like this (Forgive me if any syntax is off as my current terminal does not have Excel on it)

Now this will require your list to be in column 1, change the 1 reference found in the Cells function below

Sub SelCell()
Dim i As Long
Dim x As Long

i = 0
Do Until x > 10
i = i + 1
If IsEmpty(Cells(i, 1).Value) = True Then
    MsgBox ("Could Not Find Match")
    Exit Sub
    End If
x = Cells(i, 1).Value
Loop

Cells(i, 1).Select

End Sub

Good Luck

EDIT: Added the error catching just in case (Again Syntax may be off but looks visually correct to me)