View Single Post
  #3   Report Post  
stnkynts stnkynts is offline
Junior Member
 
Posts: 6
Default

If it was me I would just run a macro to loop through column "B" as you listed. In the example I submitted it kicks up a message box telling you what the corresponding number value is when it goes above 35.

Code:
Sub FindValue()
Dim rcount As Integer
Dim a As Integer
'gets a count of how many rows there are in column B
rcount = Range("B" & Rows.Count).End(xlUp).Row
'loops through looking for a value greater than 35 in column B
For a = 1 To rcount
    If Range("B" & a)  35 Then
        MsgBox (Range("A" & a))
        Exit Sub
    Else
    End If
Next a
    
End Sub
Let me know if you need help on how to insert or run a macro.